Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: 734 | Views in the last 30 days: 4
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...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones