restore LOG and DATA files - MS SQL 2005

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?
gopher_49Asked:
Who is Participating?
 
Steve WalesSenior Database AdministratorCommented:
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.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here