View the Recovery Model of all Databases for SQL Server

The following script is handy to view the recovery model of all the databases in SQL server.

SELECT name, recovery_model_desc

   FROM sys.databases

GO

 

If you want to change the recovery model to ‘Full’ or ‘Simple’, you can issue the following command:

USE master ;

ALTER DATABASE model SET RECOVERY <Use either FULL or Simple> ;