TSQL-Checking Database Recovery Model

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 ServerDDL Triggers to Audit Database-SQL ServerHow To Attach and Detach a Database in SQL ServerHow 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

TSQL-Checking Database Recovery Model