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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 truncate log on checkpoint

Author  Topic 

rajesha
Starting Member

36 Posts

Posted - 2002-11-06 : 23:16:42
how to set the database option "truncate log on checkpont" on in

sql2000 while am creating a new database using enterprise manager?

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2002-11-07 : 05:11:17
I don't think you can thru EM.
Create db first and then go to options to set the correct recovery model.
HTH
Franco

Go to Top of Page
   

- Advertisement -