Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-06-30 : 05:30:27
|
| What is the option to set in sql2k so that the transaction logs get truncated automatically?And also should I set the auto shrink check box checked in options of the database properties?Thanks |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-30 : 05:54:33
|
| sounds like you recovery mode: simpleI am not a fan of auto_shrink, since I think you will invariable want to grow again.CiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-30 : 05:56:30
|
| Set the database Recovery Model to SIMPLE (rather than FULL or BULK LOGGED)Personally I would turn OFF all the "Auto" switches - otherwise there is a risk that they kick in when the server is busy. Better to have them built in to your scheduled maintenance routines - i.e. running at a quiet timeKristen |
|
|
|
|
|
|
settings in 2000