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
FORUM

recovery model

recovery model

SCRIPT

Find Database Recovery Mode

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

BLOG

Recovery Models

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

FORUM

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

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

FORUM

recovery model

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

 
Contribute