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