Truncate Log on Checkpoint -- sql server new users

Sue Hoegemeier
1/13/2005 8:55:17 PM

You can set the recovery model to simple. SQL Server 2000
changed to the concept of recovery models. It's one of the
properties you can set for a database. You can set the
recovery model using alter database or in Enterprise
Manager, on the options tab for the database properties.
You can find more information on recovery models in books
online.

-Sue

[quoted text, click to view]

here NO[at]SPAM there.com
1/14/2005 2:13:17 AM

In the old days of SQL 7 this was an option on databases.

I have a couple databases that I really do not need to log and would really
like this funtionallity in SQL2000. Is there such an option hidden away

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : Truncate Log on Checkpoint