Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Quickly Reveal DB Recovery Model on all Databases.

By alanw,

I wrote this little tool out of the frustratingly slow process one must endure to find out what database Recovery Model your SQL 2000 databases are currently set to. This tool will quickly reveal whether your database Recovery model is set to either "Simple", "Full", or "Bulk-Logged."

Who has time to manually pull up "Properties" then "Options" on each database? Not us! Let's put an end to this problem!

OK - this script automatically writes and executes the necessary scripts to quickly reveal all of your database Recovery Models on all databases on a machine. Just drop it in Query Analyzer on any SQL 2000 or SQL 2005 machine - run it - and enjoy! This tool utilizes the SQL 2000 Transact-SQL function DATABASEPROPERTYEX. This tool will NOT work on SQL 6.5 or SQL 7.0. Also you will need to have full System Administrator privileges to execute this script. This script reveals information only. It does NOT alter or modify any database setting.

Here is my DBRecoveryModelGenerator Tool:

Total article views: 737 | Views in the last 30 days: 3
Related Articles

recovery model

recovery model


Find Database Recovery Mode

The scripts provided below will show you the "Recovery Mode (Model)" for any given database


Recovery Models

In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find...


SQL Server 2005 - Database Mirroring (Change of Recovery Model)

SQL Server 2005 - Database Mirroring (Change of Recovery Model)


recovery model

Are you allowed to set a user database in full recovery model if the model database is in simple mod...