Restoring from SQL transaction logs up to a named transaction

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

Product(s)

Subject


Restoring from SQL transaction logs up to a named transaction

The following procedure provides details on how to restore transactions from a transaction log up to and including a named transaction (or mark).

See How to restore from SQL transaction logs up to a named transaction.

See About restoring SQL databases and file groups

To restore from SQL transaction logs up to a named transaction

  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 Restore Job Properties dialog box, click Leave the database ready to use; additional transaction logs or differential backups cannot be restored.

  7. Select Restore log up to named transaction, and then enter the name of the transaction.

    The names are case-sensitive. Make sure you enter the correct upper- and lower-case characters.

  8. To include the named transaction in the restore, select Include the named transaction.

  9. To specify a particular named transaction in the log, select Found after and then select a date and time.

    If a date and time are not entered, recovery from the transaction log is stopped at the first transaction with the specified name.

    See Redirecting restores for SQL

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

    See Restoring data by setting job properties


Legacy ID



id-SF700149679_be2010_adm


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


Terms of use for this information are found in Legal Notices