The Blackbaud CRM database is restored using SQL Server Management Studio by doing the following:

  1. Open SQL Server Management Studio and connect to the instance of SQL Server you wish to restore the database to
  2. If you are overwriting an existing database in this instance of SQL Server, highlight the database otherwise highlight the instance of name
  3. Right click, go to Tasks, and click on restore
  4. Browse out o the backup file and go to the options tab to verify that the files are being directed to the correct folder
  5. 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.