Point-in-Time Recovery

This topic applies to Point-in-Time recovery for File level backups of SQL. Any SQL Server database that was successfully backed up using the procedures described in SQL Server Backups can be recovered to a point-in-time provided the following conditions are met:

  • An incremental backup must have been run after the base backup that precedes the point-in-time.

Tip. If you want to run base backups only, but anticipate that you might want to perform point-in-time recoveries, schedule an incremental backup to run just before each base backup after the first base backup of that database.

  • At backup, the SQL Server database was configured in Full Recovery Mode.

To recover to a point-in-time, do the following:

  1. Open the File Restore window in the management console.

  2. Click the + to the left of the database that you want to restore. This will expose all the backup jobs in the Catalog for the database.

  3. On the task panel, click Set Browse Criteria.

  4. The Set Browse Criteria dialog box appears.

  5. Set the browse period to the range as appropriate. See Filtering Displayed Jobs for a Restore Job.

  6. Open the Restore Destination Options dialog box by clicking Set Destination Options. See Chapter 28: Restore Job Options.

  7. Fill in the Point-in-Time Restore field if you are recovering to a point-in-time other than the present. Enter the date and time (to the second) of the desired point-in-time recovery in the following format:

    mm/dd/yyyy hh:mm:ss

    The hour is based on a 24-hour clock. For example, for 11:00 p.m. on March 1, 2014, enter: 03/01/2014 23:00:00

Note. If you are recovering to the present time, be sure the Point-in-Time Restore field is empty.

  1. Run your restore job.

Last updated