I am trying to insert hourly log files after a database has been changed from:
"Standby / Read-Only" mode to
regular (online) mode to
"Read-Only" mode to
"Restoring" mode to
"Standby / Read-Only" mode.
I was trying to move bak, mdf and ldf files from one drive to other drive due to the disk size.
I was trying to change the mode to "Standby / Read-Only" mode because, currently, our hourly log files can be inserted into database only if it is in "Standby / Read-Only" mode.
This log files are from a third party vendor.
I am getting following error message when I try to insert next hourly log file:
Msg 4330, Level 16, State 1, Line 3 This backup set cannot be applied because it is on a recovery path that is inconsistent with the database. The recovery path is the sequence of data and log backups that have brought the database to a particular recovery point. Find a compatible backup to restore, or restore the rest of the database to match a recovery point within this backup set, which will restore the database to a different point in time. For more information about recovery paths, see SQL Server Books Online. Msg 3013, Level 16, State 1, Line 3 RESTORE LOG is terminating abnormally. Msg 4305, Level 16, State 1, Line 3 The log in this backup set begins at LSN 385165000000462400001, which is too recent to apply to the database. An earlier log backup that includes LSN 385162000002744000001 can be restored.
When I looked at the back up file details , last LSN shows 385162000002744000001 (in orange box) , so logically, it should insert the next hourly log file.
My question is, if I change the mode like that (like it changed like 4 times), does it interrupt the process of LSN?
What does it mean by "inconsistent"?