Search This Blog

Tuesday, February 14, 2012

SQL Server - List Database Recovery Models

Nice simple queries to list all databases with recovery models

SQL Server 2000
SELECT name,DATABASEPROPERTYEX (name, 'Recovery')
FROM sysdatabases
WHERE category IN ('0', '1','16')

If you want to limit results
AND DATABASEPROPERTYEX (name, 'Recovery') = 'SIMPLE'


SQL Server 2005+
SELECT name AS [Database Name], recovery_model_desc AS [Recovery Model]
FROM sys.databases

If you want to limit results
WHERE recovery_model_desc = 'SIMPLE'
Share/Bookmark

6 comments:

  1. sql database recovery tool damaged .mdf files after using unstable software, hard drive fails, system errors. Utility restores tables, procedures and etc. items. It is compatible with any software configuration of your PC.

    ReplyDelete
    Replies
    1. Thanks for sharing the recovery guide. I would like also to suggest you a third party utility, with the help of this software we can recover your data in few minutes. Website offering free version also. visit the urls to get more information.

      http://www.recoverydeletedfiles.com/sql-database-recovery-software.html


      Thanks

      Delete
  2. I just want to suggest SQL data recovery software. It is a reliable solution to recover SQL Server database and recover corrupt MDF file. After recovery of SQL database you can open MDF file with all SQL Server editions. For more information visit: http://www.sqlrecoverysoftware.net/blog/sql-database-recovery-model.html

    ReplyDelete
  3. SQL Database MDF files can be corrupted due to one of several reasons like corrupt or damaged media, low disk space, improper shutdown, virus and spam attack, disk formatting, multiple editing of database at the same time, malfunction in operating system and even more. Doing SQL Database Repair is not as simple as doing it with third party tool.http://www.filesrepairtool.com/sql-database-repair.html

    ReplyDelete
  4. I would like to suggest you to use SQL Database recovery software to repair MDF files and perform complete SQL database recovery. To get an idea on how the software works, you need to download the free trial version of SQL recovery software from here :- http://www.tools4recovery.com/sql-database-recovery.html

    ReplyDelete
  5. To fix all error of SQL server data use SQL Database Recovery software is the best SQL database recovery tool that comes with plethora of options to recover data from damaged or corrupt SQL databases. The software can repair both the MDF and NDF SQL database files.

    So download now: http://www.softmagnat.com/sql-database-recovery.html

    ReplyDelete