November 10, 2012 at 10:19 pm
Dear,
First of all, I took the full backup of my database. After that I executed some insert queries. Then I took the differential backup of my database.
Now I have created another database and tried to restore the differential backup that has taken before. But I got the following error message.
Restore failed for Server 'A'. (Microsoft.SqlServer.SmoExtended)
Additional information:
:
-->System.Data.SqlClient.SqlError:
The log or differential backup can not be restored because no files are ready to rollforward. (Microsoft.SqlServer.Smo)
Please help me to sort out the problem.
Regards,
Akbar
November 10, 2012 at 11:00 pm
You should not create a database and then try to restore, instead you should directly restore the database with NORECOVERY mode and finish restoring differentials and the last backup you restore WITH RECOVERY.
November 11, 2012 at 12:23 am
The first step is to restore the Differential Base i.e the initial full backup with no recovery, then continue with the Differential.
To identify the relevant files via LSN numbers use the backupset and backupmediafamily tables for the full backup history of the db
Jack Vamvas
sqlserver-dba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply