If you are like us, you sometimes change your database recovery models depending on your backup method and the volatility of the data in each database.

Once in a while we’ll find that we’ve forgotten to change one.

Here’s a quick query to show you the recovery models for each database in an instance:

select name, recovery_model_desc
from master.sys.databases
order by name;

The result looks like this:

A 2 column table showing database name and recovery model

A sample query result

Not rocket science but maybe it will save someone a few minutes.

Hope this is helpful!

Leave a Reply

Your email address will not be published. Required fields are marked *

 characters available