• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

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?
0
gopher_49
Asked:
gopher_49
1 Solution
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now