Thursday, February 25, 2010

how to Set DATA BASE recovery mode full ?

Set data base recovery mode is full?
Run folliing sql in to your querry analizer.
USE master;
--Make sure the database is using the full recovery model.
ALTER DATABASE AdventureWorks SET RECOVERY FULL;
GO

Change AdventureWorks to your data base name.

No comments:

Post a Comment