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
This entry was posted in Database Administration, Joy of T-SQL, SQL General Information, T-SQL Tips & Tricks. Bookmark the permalink.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s