TSQL-Checking Database Recovery Model

In this post we will learn how to check recovery model of all database hosted on your SQL Server or you can say TSQL-Checking Database Recovery Model. This is very easy we just have to run a script to do this.

Earlier we had discussed about Change Data Capture in SQL Server, DDL Triggers to Audit Database-SQL Server, How To Attach and Detach a Database in SQL Server, How To Backup Your SQL Server Database and How To Compare 3 Numbers Using TSQL In SQL Server.

Script:

Use master
go
SELECT [name],state_desc,recovery_model_desc FROM sys.databases
go