Home Forums SQL Server 2008 SQL Server 2008 - General Problem in Restoring Differential Backup in SQL Server 2008 R2 RE: Problem in Restoring Differential Backup in SQL Server 2008 R2
Superdoc
SSCommitted
Points: 1654
More actions
November 10, 2012 at 11:00 pm
#1557946
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.