February 23, 2013 at 10:07 am
Dear Experts
I have taken a full backup at 3 am, log backups at 12 pm and 3 pm, and differential backup at 6 pm
now I am trying to resore database on another sql server
first,I restored full backup with no recovery
then, I restored log
then trying to restore differential
but this error is raised
The log or differential backup cannot be restored because no files are ready to rollforwared
any idea what should I do
Thanks
February 23, 2013 at 10:12 am
Restore full, then differential. Thats enough to have as per your backups.
Cheers,
- Win
"Dont Judge a Book by its Cover"
February 23, 2013 at 10:29 am
The error is because you restored a log backup WITH RECOVERY.
Besides, that's the wrong order. Restore full, the last diff and then the log backups to reach the point you want to restore to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2013 at 7:34 am
Hi,
you have three types of backups.
full - which can be restored independent from any other backup
differential - which is based on the recent full backup
log - which is based on the recent differential or full backup
In conclusion that mean:
1. Restore the recent full backup
2. Restore the recent differential backup after the before restored full backup - and forget all log backups before this differential backup
3. Restore all log backups after the before restored differential backup in the timely order
I hope that makes it clear enough. 😉
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply