November 6, 2002 at 9:31 pm
how to set the database option "truncate log on checkpont" on in
sql2000 while am creating a new database using enterprise manager?
November 7, 2002 at 3:49 am
In sql 2000 the simple recovery model is comparable with truncate log on checkpoint.
In enterprice manager:
right click the database, select properties goto the options tab.
November 7, 2002 at 4:17 am
If this will be the default setting for all future databases set it instead in the model database. Remember when you create a database it is based on the models defaults and objects. Then you just create your databases and only alter when you need to.
November 9, 2002 at 8:26 pm
Also check in BOL for the Full recovery mode of SQL 2000. Maybe you should consider it.
November 10, 2002 at 9:20 am
Full recovery is does not map to sql 7 truncate log on checkpoint.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply