Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem in Restoring Differential Backup in SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Saturday, November 10, 2012 10:19 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
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
Post #1383419
Posted Saturday, November 10, 2012 11:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:40 AM
Points: 47, Visits: 813
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.
Post #1383421
Posted Sunday, November 11, 2012 12:23 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 7, 2014 8:21 AM
Points: 33, Visits: 325
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
Post #1383424
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse