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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-08-31 : 09:26:57
|
| anyone know where is the "truncate log on checkpoint option" on sql server 2000?=============================http://www.sqlserverstudy.com |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-08-31 : 11:25:52
|
| In SQL 2000 that is akin to setting to SIMPLE RECOVERY MODE, but it can be done using sp_dboption the option name is trunc.log on chkpt. /*-----------------------Words are but constrained thoughts.------------------------*/ |
 |
|
|
|
|
|
truncate log on checkpoint option