戻る
-
タイトル
MSSQL Differential restore fails with "This differential backup cannot be restored because the database has not been restored to the correct earlier state" -
説明
When using a strategy where a Full backup runs once a week and differentials or incrementals run daily, if a one off full backup is run manually after the scheduled full this may affect later restore attempts.
If an attempt is made to restore a database by restoring the normal full first and then a differential taken after the one off full, the job will fail because a full backup has been created some time between the weekly scheduled full and the differential stored in NetVault.
The below error will be returned:
ODBC Error Number:42000, MsgState=1, Severity=16, Servername= ProcName=, LineNumber=1, Message:[Microsoft][ODBC SQL Server Driver][SQL Server]This differential backup cannot be restored because the database has not been restored to the correct earlier state.Differential Restore: Be sure you have restored the corresponding full database as non-operational or read only.Error restoring database