Hi All,
I am taking transaction log backup every six hours. Which
backup should i use to restore so that i can get the table
which i want. How can i go about pls help me as its very
urgent.
TIA
RegardsHi
Restore your last full backup and all the tx logs in order since the full backup until you get to the log backup where you want restore from. On the restore screen you will be able to select a point in time within the tx log if you want. Restore this full backup and subsequent tx log backups to a different database name (this is very important, do not overwrite your production database!!). Then use "DTS Export Data" to export your table from the restored database over the production table.(Do this by right clicking on your restored database and saying export data...follow the wizard)
All the best
J
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment