It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Campus Barracuda Campus
Barracuda Backup
Overview Documentation Training Certification Materials

How to Restore a Microsoft SQL Database to a Point-in-Time

  • Last updated on

Flat File
This article describes how to restore a SQL database to a point-in-time, and then restore the database to working condition using SQL Management Studio. Before completing this solution, you must first Restore the Microsoft Database to a Flat File.

Step 1. Restore the Database

Use the following steps to restore the database:

  1. Open Microsoft SQL Server Management Studio, and navigate to Databases:
    sqlMgmt.jpg
  2. Right-click Databases, and click Restore Database.  In the Source for restore section, select From Device, and click the browse button:
    sqlMgmt2.jpg 
  3. Click Add in the Specify Backup window.  Browse to the location of your recently restored flat files. Choose the Full backup file which should be the first backup file in the list:
    sqlMgmt3.jpg
  4. Click OK; the Specify Backup window displays:
    sqlMgmt4.jpg
  5. Click OK. In the Destination for restore section, select the database to which you wish to restore, and in the Select the backup sets to restore section, select the backup file you selected above in step 3:
    sqlMgmt5.jpg 
  6. In the left pane, click Options, and select the following:
    • In the Restore options section, select Overwrite the existing database (WITH REPLACE), and leave the other options unselected.
    • In the Recovery state section, select Leave the database non-operational, and do not roll back uncommited transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY):
      sqlMgmt6.jpg
  7. Click OK to perform the restore.
  8. Complete these steps for each incremental backup file, including the .tm file, until you reach the incremental file containing the point-in-time file to which you wish to restore.
  9. A "Restoring" message displays; you can now proceed with the next section, Step 2. Restoring to a Point-in-Time.

Step 2. Restore to a Point-in-Time

Use the following steps to restore the last incremental file containing the point-in-time:

  1. In Microsoft SQL Server Management Studio, right-click Databases, and click Restore Database.
  2. In the Source for restore section, select From Device, and click the browse button.
  3. Click Add in the Specify Backup window. Browse to the location of your recently restored flat files, select the incremental backup file containing the point-in-time to restore to, and click OK.
  4. Click OK in the Specify Backup window. In the Select the backup sets to restore section, check the backup file you added in the previous step.
  5. In the Destination for restore section, select the database to which to restore:
    sqlMgmt8.jpg
  6. In the Destination for restore section, click the browse button following To a point in time; the Point in time restore window displays.
  7. Select a specific date and time, and choose the date and time to which to restore:
    sqlMgmt7.jpg
  8. Click OK. In the left pane, click Options, and make the following selections:
    • In the Restore options section, select Overwrite the existing database, and leave the other options unselected.
    • In the Recovery state section, select Leave the database ready to use by rolling back uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH RECOVERY):
      sqlMgmt9.jpg
  9. Click OK to perform the restore. the restored database should display with only the changes up to the specified point-in-time.
Previous Article Next Article