Dell Avamar for SQL Server 19.7 User Guide

Restoring a database with SQL Server Management Studio

You can restore a database from a SQL formatted backup file to SQL Server by using the user interface in SQL Server Management Studio. The Microsoft website provides full details on how to use SQL Server Management Studio to restore a database backup.

1. Restore the database backup to a file by using the instructions in one of the following topics:
   • Restoring to a file with the SQL Server plug-in
   • Restoring to a file with the Windows File System plug-in
2. Ensure that the SQL backup format files that you restored are accessible to SQL Server. You may need to make the data visible to SQL Server or copy the data.
3. Restore the full backup (f-0 file) to SQL Server:
   1. Open the Restore Database window.
      • If the database already exists, then right-click the database in the Object Explorer and select Tasks > Restore > Database.
      • If the database has been lost, then right-click the Databases node in the Object Explorer and select Restore Database.
   2. On the General page of the Restore Database window, select From device.
   3. Click the ... button.
      The Specify Backup dialog box appears.
   4. Click Add.
      The Locate Backup File dialog box appears.
   5. Select the folder in which the full backup files are located.
   6. From the Files of type list, select All files(*).
   7. Select the full backup (f-0) file.
   8. Click OK.
   9. If there are multiple full backup files from multi-streaming (such as f-0.stream0, f-0.stream1, f-0.stream2, and so on), then repeat step d through step h to add each file.
   10. Click OK on the Specify Backup dialog box.
   11. On the General page of the Restore Database window, select the checkboxes next to the backup files to restore.
   12. In the left pane, click Options to open the Options page.
   13. In the Restore the database files as list, select each file and click the ... button to specify the location to which to restore the files.
   14. For Recovery state, select RESTORE WITH NORECOVERY.
   15. Click OK to begin the restore.
4. Restore the differential (d-n) or transaction log (i-n) files in order from the oldest to the most recent:
   1. In the Object Explorer, right-click the database and select Tasks > Restore > Database.
   2. On the General page of the Restore Database window, select From device.
   3. Click the ... button.
      The Specify Backup dialog box appears.
   4. Click Add.
      The Locate Backup File dialog box appears.
   5. Select the folder in which the differential or transaction log backup files are located.
   6. From the Files of type list, select All files(*).
   7. Select the differential (d-n) or transaction log (i-n) backup file, where n is the sequential number of the differential or incremental backup since the preceding full backup.
   8. Click OK.
   9. If there are multiple differential or transaction log backup files from multi-streaming (such as d-3.stream0, d-3.stream1, d-3.stream2, or i-6.stream0, i-6.stream1, i-6.stream2, and i-6.stream3), then repeat step d through step h to add each file.
   10. Click OK on the Specify Backup dialog box.
   11. On the General page of the Restore Database window, select the checkboxes next to the backup files to restore.
   12. In the left pane, click Options to open the Options page.
   13. In the Restore the database files as list, select each file and click the ... button to specify the location to which to restore the files.
   14. For Recovery state, select RESTORE WITH NORECOVERY for all except the most recent backup file. When you restore the most recent backup file, select RESTORE WITH RECOVERY.
   15. Click OK to begin the restore.
5. If the database is not already listed in SQL Server Management Studio, then refresh the list or connect to the database.