Recovery Model for each Database on a Server (FULL or SIMPLE)

This query will return the Recovery Model (FULL or SIMPLE) for each Database on a SQL Server


Auditing - script to create an auditing table
Backing up SQL Express
Backup Database Tutorial (2008)
Backup Database Tutorial (2014)
Backup one database and restore to another in a script
BULK INSERT
Create a table on a linked server
Creating SSIS Packages from Visual Studio 2019
Decrypt a Stored Procedure
How to change the DB Collation for a Dynamics GP server
Logins - Drop multiple logins from all databases
Recovery Model for each Database on a Server (FULL or SIMPLE)
Restore Database Tutorial (2008)
Restore Database Tutorial (2014)
Run a script against all databases
Run a script against all Dynamics GP company databases
Turn off SQL Compression

SELECT name, recovery_model_desc from master.sys.databases

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.

Links
Home
Knowledge Areas
Sitemap

Contact

Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences

Related Articles