Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.
COURSE of the MONTH
11 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
restore LOG and DATA files - MS SQL 2005
Posted on 2013-10-23
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active today
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 ?
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 ?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses
Course of the Month11 days, 3 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.