How to change the recovery model of a SQL Server database

This solution describes the steps to change the recovery model for SQL Server databases.

Article
Number:38317

Products:

Education_Edge_EE

Financial_Edge_FE

Raiser_s_Edge_RE

Student_Billing

SQL Server defines three recovery models that a database can be run in: Simple, Full, and Bulk-Logged. The recovery model of a database determines how much data loss is acceptable, assuming an event of server or other failure, and what types of backup and restore functions are supported for the database(s). For more information on the recovery models available, and the options supported by each, see Microsoft's Recovery Model Overview.

By default, Blackbaud databases are set to use the simple recovery model. While changing the recovery model of a database is easily accomplished, it is very important to understand the potential impact each model has on database performance, log file size, and database backup and restore strategies.

Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist with implementing resolutions from these websites.