Tuesday 11 April 2017

Check database Recovery model status :

Execute the below query , we can see type of recovery model consisting by the database.
SELECT name, (SELECT DATABASEPROPERTYEX(name, 'RECOVERY')) RecoveryModel 
FROM master..sysdatabases ORDER BY name

No comments:

Post a Comment