Restore a Fusion Database

Before You Restore a SQL Database

• Ensure that your SQL server is up and running.
• Ensure that Mixed Mode Authentication is installed.
• Verify that you have the required role to perform a restore operation. Administrator or Backup Operator roles are usually required.
• Locate the backup file you want to restore on your machine. The backup file has the extension .bak for an SQL server.

  Note: Blank Central Databases are available on the Datamine Product Store.

To restore a database using SQL Server Management Studio (SSMS):

1. Open Server Management Studio (SSMS).

   The Connect to Server window displays.

2. Enter the following Server details:
   • Server type
   • Server name
   • Select the Authentication method. If required, enter your login credentials.
3. Enter the following Connection Security details:
   1. Select the Encryption type.
   2. Select whether to Trust server certificate.
   3. If Strict is selected as the Encryption type, enter the Host name in certificate.
4. Click Connect.

   The nodes for the database display in the Object Explorer window.

5. Right-click the Databases node and select Restore Database... from the menu.

   The Restore Database window displays.

6. Select the General page.
   1. Set the Source to Device.
   2. Click the browse icon ....

      The Select backup devices window displays.

   3. Set the Backup media type to File.
   4. Click Add.

      The Locate Backup File window displays.

   5. Browse for and select the required .bak file.
   6. Click OK.
   7. Click OK again.
   8. The fields on the General page automatically update based on the information from the selected database.

      Note: You can Restore to an existing database and overwrite the database or you can create a new database.

   9. Ensure that your database has Restore checked in the Backup sets to restore section.
7. Click OK.

   The database displays in the Databases node in the Object Explorer.