For complete instructions on backing up and restoring via Microsoft SQL Server Management Studio (SSMS), refer to the following Microsoft articles:
- SQL Server 2008 R2 Backing Up and Restoring How-to Topics
- How to Back Up a SQL Server 2008 R2 Database
- How to Restore a SQL Server 2008 R2 Database Backup
- Full Database Backups
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.
Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.
A complete backup process includes making regular backups, storing them on external media, and testing them regularly to ensure validity.
Note: This is not supported for products that use the Blackbaud Management Console.
Note: Before using Microsoft SQL Server Management Studio to back up and restore databases, please refer to How to make a backup and restore from or test the backup to view the approved backup methods for all Blackbaud products.
Important Note: If your organization integrates multiple Blackbaud products, or integrates with any of third-party products, there are additional requirements for backing up and restoring databases:
- Users should not be entering data at the time the scheduled backups are run
- Integration scheduled tasks or SQL Server jobs must be disabled during the scheduled backups
- All databases must be backed up in succession
If you find it necessary to restore one product database, you must also restore all other product databases from the same backup set. Failure to do so may result in a broken integration between products; repairing and re-integrating products is a billable service.