Comments
6 comments
-
We are investigating this under a support ticket. If any other users experience this please do reply here and we will look into this for you.
-
Having the same issue , does any one have an answer, the first error was (The log in this backup set begins at LSN 936699000000029700001, which is too recent to apply to the database. An earlier log backup that includes LSN 934385000001789300001 can be restored.)
when i manually did the restore from the earliest LSN it was success and now this error
The REPLACE option must be used when using the DISCONNECT_EXISTING option on an active database.
-
Having same issue, is there a resolution on this ?
-
Dan B said:We are investigating this under a support ticket. If any other users experience this please do reply here and we will look into this for you.
-
The error message indicates that the transaction logs are being restored out of sequence. You need to determine if the earlier transaction log backup file does exist in the folder where SQL Backup is restoring from, and if so, why SQL Backup is not picking up that file to restore.
It could be something like the earlier transaction log backup having a password, while the later ones do not, and the restore command now does not provide a password. Or a situation where SQL Backup failed to fill in the backup details for that earlier backup, causing SQL Backup not to be able to identify that backup set correctly.
If you cannot find the required file, then it could be that the SQL Backup service on the backup server failed to copy the file over (if you were using the COPYTO option), or a transaction log backup was made outside of SQL Backup, in which case you'll need to track down that file using details from the msdb..backupset and msdb..backupmediafamily tables on the backup instance. -
Add comment
Please sign in to leave a comment.
The REPLACE option must be used when using the DISCONNECT_EXISTING option on an active database.
Thanks