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 |
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
-
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.
-
On the Properties pane, under Settings, click Microsoft SQL.
-
On the Restore Job Properties dialog box, click Leave the database ready to use; additional transaction logs or differential backups cannot be restored.
-
Select Point in time log restore, and then select a date and time.
-
Start the restore job or select other restore options from the Properties pane.
|
|
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
Thank you.