Hi tyang,
quote:
Will the log size be increased if I uncheck the auto close option?
autoclose just means, that this db will automatically close when the last user disconnects. Default is, that SQL Server keeps all db files open all the time. I don't think, this will affect log files, though it will affect performance
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]