Different Ways to Find Recovery Models in SQL Server
Today I was going through recovery models so thought to share different ways how we can find recovery models in SQL Server 2012.
Execute below query in query editor and find the recovery model.
SELECT name, recovery_model_desc FROM sys.databases GO
Execute below query and check the recovery model in STATUS column.
EXEC sp_helpdb GO
You can find the Recovery model through SSMS also as given in below path.
Go to Object Explorer –> Databases –> Right click on Database –> Select Properties –> Select Options Page
In Object Explorer, Select Databases node and Press F7, you can find the recovery model under Recovery Model column.
Put your database name in query and execute.
SELECT DATABASEPROPERTYEX ('DBName', 'RECOVERY') "Recovery Model" GO
Right click on database and select Facets and you will find the detail in recovery model property.
If you know any other option, please do share with us. 🙂
CLICK HERE to watch live practical.
Reference: Manzoor Siddiqui [www.SQLServerLog.com]