May 3, 2007 at 8:55 am
hi all
I need to restore a database from a live environment onto a test environment. The restore operation must recover the database to an exact point in time at the end of a batch operation. Normally I would just set up a job to backup the live database at the end of batch. However, the backup will take about 40 mins to complete. I have done a bit of playing around with this and discovered that the changes made in that 40 min window will also be restored - which I don't want.
Can anyone confirm/deny that my findings are correct and that I'll need to think of an alternative strategy to restore the test system.
thanks in advance
Stuart
May 3, 2007 at 10:32 am
Stuart,
I get the impression that you're using a full database backup. Real point-in-time recovery is only possible if you are taking log backups in addition to full backups. So, if you take a log backup immediately after the batch operation, you can restore to the exact time that you want even if other modifications were made to the data while the backup was running.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply