October 22, 2009 at 11:03 am
Hi,
I made a full backup of our database on server1 and restored it to a server2.
After a few hours I made a differential backup on server1 and tried to restore it on server2 but i gave the following message:
Msg 3117, Level 16, State 1, Line 1
The log or differential backup cannot be restored because no files are ready to rollforward.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any one knows why?
My purpose with this is the following: we have a database with almost 1T of data and we are moving our infrastructure to another datacenter 300Km away. We have the new machine configured just like the actual one. I planned to make a full backup 2 days before the final migration and restore it on the new server. on the migration day, to minimize downtime, we'll make a differential backup of the database and download it (differential backup should be just 1G, much faster download than 1T), but I have this error....
Can anyone help on this?
Thanks,
Pedro
October 22, 2009 at 11:07 am
Sorry to bother...
just figured it out....
On the first restore the database base must be left in "non-operational, and do not roll back uncommitted transaction" (RESTORE WITH NORECOVERY)....
Then I can restore the differential backup and get the database up to date..
By the way... For this purpose the second backup should be a differential or a transaction log backup?!
Thanks,
Pedro
October 22, 2009 at 12:26 pm
If you can get the differential backup taken, copied and restored in a time that gives an acceptable outage, stick with it. If you want to reduce outage even more, do the differential just before then at swap over time take a final transaction log backup.
---------------------------------------------------------------------
October 22, 2009 at 1:37 pm
Thanks... that decreases even more the downtime...
Thanks,
Pedro
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply