April 17, 2009 at 1:56 pm
If I read the documentation correctly, setting a database to the SIMPLE recovery model automatically truncates the log at checkpoints. But there's still the option to "Truncate Log On Checkpoint". Is it safe to ignore this option when using SIMPLE... should it be true/false?
These databases are SQL 2000 and 2005 - I thought I read that the recovery model trumps this setting regardless. Is that true?
Thanks,
Mike
April 17, 2009 at 2:36 pm
Ignore that setting and don't mess with it. It's there only for backward compatibility (SQL 7 and earlier I think), it is deprecated, it will be removed in future versions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 17, 2009 at 2:44 pm
That's part of the problem... some databases have it set, others don't, but almost all databases are using SIMPLE recovery model. I'd like them to be uniform so if someone goes in to look, they don't end up with the same question I have - "Everything else is the same but this one switch... what's it for?"
April 18, 2009 at 2:23 am
Set them all to whatever the default is (Books online should tell you that)
From SQL 2000 onwards you should just be using the recovery models (full, bulk logged and simple) and not touching that setting.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 8:02 am
Thanks, Gail!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply