Trying to do a restore from a Differential session of an MS SQL Database and receives the error “ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] This differential backup cannot be restored because the database has not been restored to the correct earlier state."
The Error message itself is coming from MS SQL, not Netvault. What MS SQL is basically saying is that the differential does not belong or match up with the full that Netvault is trying to use.
One very common cause of this is if some other utility or program was used to backup or archive the database in some way, then that would have reset the starting point for the full and would be the reason why MS SQL will not accept the restore sequence from Netvault.
The reason for this is due to the fact that the transaction logs were truncated between the full and the differential backup resulting in the MS SQL error when attempting to recover the differential backups.
Example:
The differential incremental Microsoft SQL backup needs to be applied to the last full backup that was run before it.
For example:
6/14/20 - A full Microsoft SQL backup was done on the database Northwind by the NetVault SQL Plugin Agent
6/15/20 - A full Microsoft SQL backup was done on the database Northwind by a database administrator using Microsoft SQL backup
6/16/20 - A cumulative differential Microsoft SQL backup was done on the database Northwind by the NetVault SQL Plugin Agent
In this scenario, the full backup done on 6/15 using Microsoft SQL backup would have to be restored, not recovered, before the cumulative differential 6/16/08 backup can be restored from NetVault. Attempting to restore the 6/14/20 full backup and then the 6/16/20 cumulative differential backup would result in the error cited above.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center