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.
For information on what to consider before changing a database from the simple recovery model, please see Microsoft's Considerations for Switching from the Simple Recovery Model.
For more information on changing the recovery model of a database, see Microsoft's How to: View or Change the Recovery Model of a Database (SQL Server Management Studio).
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.
Connect and collaborate with fellow Blackbaud users.