I have two SQL Server database backups from
Backup1 was made on, say, 2013-01-01 and
Backup2 was made on 2013-01-03. What I want to do is restore
Server2 to the intermediate state on 2013-01-02.
What I am trying to do is the following:
Backup2onto Server2 so it has the latest data.
- Backup the transaction log on Server2.
- Restore the transaction log using
STOPAT = "2013-01-01 23:59:59"
I'm pretty sure I understand why this doesn't work. In step 2, I want the transaction log to go back to a certain backup, but there's no way to tell SQL Server which one I want. It just picks the latest one.
If that's correct, then I guess my question is, how can I trick SQL Server into giving me the transaction log I need. I've been looking at the
backupset table and wondering if I can modify that to get what I need.
Server2 is a development server and not in production. I can modify it as necessary, even into an unusable state if it will help me get this data correct.