SQLjuMBLe
Knowledge will start from you, SQLjuMBLe for those who Do.
Menu Bar
Home
Python
MS SQL Server
VB6/VBA
Power BI
MSBI
Technologies
Puzzle Round
Health
Story of The Day
About Me
Contact Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment