November 4, 2008 at 11:29 am
Hi,
Our database is corrupted at 9:50am.We have full backup at 2am and differential at 6am and every 15 min log backup.
So I,decided to restore the database upto 9:45am By Restoring
2am full backup
6am diff backup
6:15am to 9:45am log backups.
I restored the full backup with norecovery and trying to restore 6am differential with norecovery it giving me the following error? could plz advice me where Iam doing the wrong things.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'sqldba1\ins1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00
&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: This differential backup cannot be restored because the database has not been restored to the correct earlier state. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
November 4, 2008 at 11:43 am
I'd check to see if another full backup was run between 02:00 and 06:00. Start by checking the msdb.dbo.backupset and msdb.dbo.backupfile tables.
Also, if the full backup actually was completed successfully.
November 4, 2008 at 11:53 am
Mani (11/4/2008)
This differential backup cannot be restored because the database has not been restored to the correct earlier state. (Microsoft.SqlServer.Smo)
That's saying that the 6am diff is not based off the full backup that you restored before. A diff is based off of the last full backup run. You may have another backup job backing up somewhere else, or someone may have taken an ad-hoc backup (though that's not all too likely between 2am and 6am)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 4, 2008 at 5:40 pm
Just a work around... to what you are doing now...
Apply full backup and apply all Transactional Log backups taken after Full backup.
If you have a media device then... you can restore all but one transactional log backups with No Recovery in just one click. The last log backup ( the most recent one) restore with Recovery
This will the remove option of Differential backup usage...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply