Wednesday, March 28, 2012

recovery model

Hello,
how to know what's my database's recovery model? hwo to change it? Thanks.>> how to know what's my database's recovery model?
SELECT DATABASEPROPERTYEX( 'your db', 'Recovery' )
Use ALTER DATABASE command and its various options in SQL Server Books
Online. Alternatively, you can change it using the database properties in
the EM console interface as well.
Anith

No comments:

Post a Comment