SQL Server Performance Forum – Threads Archive
Error while restoring differential backupHi,
After running restore command for full database backup. restore database psf1 from disk = ‘ESF1Full.bak’
with NORECOVERY when I am trying to restore the differntial set.
restore database psf1 from disk = ‘ESF1diff.bak’
with NORECOVERY I am getting this error Server: Msg 3136, Level 16, State 1, Line 1
Cannot apply the backup on device ‘ESF1diff.bak’ to database ‘psf1’.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Has anyone encountered similar problem?Any help in this regard would be much appreciated.
Never mind.Found the problem.Somebody took another backup between my full and differential backups.