Restoring from SQL transaction logs up to a point in time

Article:HOWTO24040  |  Created: 2010-01-01  |  Updated: 2011-06-15  |  Article URL http://www.symantec.com/docs/HOWTO24040
Article Type
How To

Product(s)

Subject


Restoring from SQL transaction logs up to a point in time

The following procedure provides details on how to restore transactions from a transaction log up to and including a point in time in the transaction log.

See How to restore from SQL transaction logs up to a point in time.

See Restoring data by setting job properties

See About restoring SQL databases and file groups

See Restoring from SQL transaction logs up to a named transaction

To restore from SQL transaction logs up to a point in time

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. On the Properties pane, under Source, click Selections.

  4. In the restore selections list, select the most recent full database backup set, and the most recent differential database backup set, if any, and all the log backup sets you want to restore.

  5. On the Properties pane, under Settings, click Microsoft SQL.

  6. On the Restore Job Properties dialog box, click Leave the database ready to use; additional transaction logs or differential backups cannot be restored.

  7. Select Point in time log restore, and then select a date and time.

    See SQL restore options

  8. Start the restore job or select other restore options from the Properties pane.

    See Restoring data by setting job properties


Legacy ID



id-SF700138226_be2010_adm


Article URL http://www.symantec.com/docs/HOWTO24040


Terms of use for this information are found in Legal Notices