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
FROM sysdatabases
WHERE category IN ('0', '1','16')

If you want to limit results

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'


  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.

    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.


  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:

  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.

  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 :-

  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: