Showing posts with label how to Set DATA BASE recovery mode full. Show all posts
Showing posts with label how to Set DATA BASE recovery mode full. Show all posts

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.