The Blackbaud CRM database is restored using SQL Server Management Studio by doing the following:
- Open SQL Server Management Studio and connect to the instance of SQL Server you wish to restore the database to
- If you are overwriting an existing database in this instance of SQL Server, highlight the database otherwise highlight the instance of name
- Right click, go to Tasks, and click on restore
- Browse out o the backup file and go to the options tab to verify that the files are being directed to the correct folder
- Click ok
After the database has been restored, you will need to regenerate the master key. The master key was created and is managed by your database administrator.