Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 2137539 - Last Review: April 2, 2012 - Revision: 2.0
FULL or BULK recovery models can provide better data protection and recovery
Using a database recovery model of FULL or BULK can provide better data protection and recovery for your database than a SIMPLE recovery model. For example, a FULL recovery model allows an administrator to:
- Perform transaction log backups
- Backup the current transaction log should the database file(s) become lost
- Restore pages from a database backup
For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:
Collapse this tableExpand this table
| Rule software | Rule title | Rule description | Product versions against which the rule is evaluated |
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)
| Databases using simple recovery model
| The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect if a database is using the SIMPLE recovery model. The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2. If you run the BPA tool and encounter a Warning with the title of Engine - Databases using simple recovery model, then your SQL Server 2008 or SQL Server 2008 R2 installation has one or more databases using the SIMPLE recover model. BPA will exclude any instance using SQL Server Express Edition from this check. In addition, it excludes the following databases:      - master
- model
- msdb
- tempdb
- ReportServerTempdb
- The database for "Management Data Warehouse" feature (by using the fn_listextendedproperty function to look for a property with the name like "Microsoft_DataCollector"
- The distribution database for replication
- Any database that is READONLY
| SQL Server 2008
SQL Server 2008 R2
|
SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)
| Databases using simple recovery model
| The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect if a database is using the SIMPLE recovery model. If you run the BPA tool and encounter a Warning with the title of Engine -Databases using simple recovery model, then your SQL Server 2012 installation has one or more databases using the SIMPLE recover model. BPA will exclude any instance using SQL Server Express Edition from this check. In addition, it excludes the following databases: Â - master
- model
- msdb
- tempdb
- ReportServerTempdb
- The database for "Management Data Warehouse" feature (by using the fn_listextendedproperty function to look for a property with the name like "Microsoft_DataCollector"
- The distribution database for replication
- Any database that is READONLY
| SQL Server 2012Â
|
APPLIES TO
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Enterprise X64 Edition
- Microsoft SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft SQL Server 2005 Workgroup Edition
- Microsoft SQL Server 2008 Developer
- Microsoft SQL Server 2008 Enterprise
- Microsoft SQL Server 2008 Express
- Microsoft SQL Server 2008 Express with Advanced Services
- Microsoft SQL Server 2008 R2 Datacenter
- Microsoft SQL Server 2008 R2 Developer
- Microsoft SQL Server 2008 R2 Enterprise
- Microsoft SQL Server 2008 R2 Express
- Microsoft SQL Server 2008 R2 Express with Advanced Services
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate