I have a series of LOG and DATA SQL backups. The LOGS date back to 11/1/12 and the DATA is current as of 9/27/13. I want to restore the DB as far back as 9/23/13. How do I do that if my full backup is on 9/27/13?
If your last full backup is 9/27/13 then you can't go backwards.
Logs only apply forwards.
If you want a recovery to 9/23 then you'd need a full backup at a point in time before 9/23 and then you can roll transaction logs forward to the point in time you want to stop at on 9/23.
Do you have any other full backups prior to 9/27 available ?
0
gopher_49Author Commented:
The server admin might... I'll have to check. Most likely the 9/27/13 backup will be fine. The data hasn't changed since then. My backups don't see changed data since 9/30/13 and I believe they removed the DB since then.
I'll close the ticket.
Thanks.
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Logs only apply forwards.
If you want a recovery to 9/23 then you'd need a full backup at a point in time before 9/23 and then you can roll transaction logs forward to the point in time you want to stop at on 9/23.
Do you have any other full backups prior to 9/27 available ?