SET DATABESE RECOVERY MODEL

Today round date 10/10/10 is a very reason for me to add a new post.

In sql server 2000 that we do not have a gui to change recovery model use bellow code.You can use this code in sql server 2005 and 2008.


ALTER DATABASE test_db SET RECOVERY FULL

We know that we can use FULL, SIMPLE and BULK_LOGGED

Advertisements

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s