How To See Recovery Model In SQL Server

In this blog entry I like show how to see the backup recovery model for all database in SQL Server. Of course, there are many ways to see this information but in this case with this simple query you can see it for all databases into the instance;

 

SELECT NAME AS [DATABASE NAME],
RECOVERY_MODEL_DESC AS [RECOVERY MODEL] FROM SYS.DATABASES
GO

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s