SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Hi @Edward Hall ,
Did you get the solution? I am having the same issue...
sql log shipping restore failure
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 13%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEH%3C/text%3E%3C/svg%3E)
Edward Hall
1
Reputation point
What is causing this error and how do i correct it.
2021-02-02 10:06:04.32 Error: Could not apply log backup file '\secondary\SQLLogShip\dbname_20210201143000.trn' to secondary database 'dbname'.(Microsoft.SqlServer.Management.LogShipping)
2021-02-02 10:06:04.32 **Error: An error occurred while processing the log for database 'dbname'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
An error occurred during recovery, preventing the database 'dbname' (19:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
RESTORE LOG is terminating abnormally.
Processed 0 pages for database 'dbname' file 'dbname' on file 1.
Processed 1 pages for database 'dbname', file 'dbname_log' on file 1.(.Net SqlClient Data Provider) **
2021-02-02 10:06:04.33 Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping)
Some history.
we have several databases log shipped into standby mode for reporting purposes to the same secondary server most work fine but we have a small few that do not. We have duplicated the settings from the working ones to this one. Didn't help, Both servers are the same versions.
once we delete it and re setup the log shipping on a 15 min interval with disconnect users selected it will run normally 1 or 2 cycles then this error shows up. I have tried to get it going but it has to be re setup to get back to working again. it seems to run ok with "norecovery" selected, but that is useless for reporting functions. There is a second log backup job but this database is excluded. We even tried suspending that 2nd job, that didn't make any difference. The same error shows up on the 2nd or 3rd cycle.
We have run out of ideas to check.
SQL Server | Other
-
Edward Hall 1 Reputation point
2021-02-03T15:39:56.227+00:00 sql server log on this failure
Date 2/3/2021 9:36:01 AM
Log SQL Server (Current - 2/3/2021 8:14:00 AM)
Source spid71
Message
Setting database option SINGLE_USER to ON for database 'DBname'.Date 2/3/2021 9:36:02 AM
Log SQL Server (Current - 2/3/2021 8:14:00 AM)
Source spid71
Message
Starting up database 'DBname'.Date 2/3/2021 9:36:04 AM
Log SQL Server (Current - 2/3/2021 8:14:00 AM)
Source spid71
Message
An error occurred while processing the log for database 'DBname'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.Date 2/3/2021 9:36:04 AM
Log SQL Server (Current - 2/3/2021 8:14:00 AM)
Source spid71
Message
An error occurred during recovery, preventing the database 'DBname' (19:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
Sign in to comment
3 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 59%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Reinaldo J Blanco Medina 21 Reputation points2021-08-31T14:24:19.497+00:00 -
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator2021-08-31T21:16:30.05+00:00 Rather than piggybacking to an old thread, it is better to ask a new question, including all details that are relevant for your problem. While you may be seeing the same symptoms, the underlying problem, and thus the solution, may be different.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT 6,676 Reputation points2021-02-03T07:50:45.107+00:00 Hi @Edward Hall ，
Please look into the SQL Server ERRORLOG,windows Log for any errors related to log shipping.
In addition, here is a fix that may be applicable to your situation, please check.
-
Edward Hall 1 Reputation point
2021-02-03T14:01:55.957+00:00 you mentioned "here is a fix" i dont see anything. where should i be looking im new here. :)
-
Edward Hall 1 Reputation point
2021-02-03T15:42:03.843+00:00 you mentioned a fix. i dont see any fix where shoould i be looking?
-
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2021-02-03T22:03:47.513+00:00 If you look closely on Cris's post, you find that the word "fix" is in blue. This means that it is a link you can click on.
It appears that the error messages in the errorlog did not tell us anything new.
What does "SELECT @@version" report?
Sign in to comment -
-
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2021-02-02T22:14:20.263+00:00 It looks like the original error message which relates why it was not possible to apply to the log has gone lost somewhere.
I would first check the SQL Server error log in hope that it may be there.
If that does not work out, I would try to trace errors on the SQL Server machine. As it happens, I have an article on my web site on how do this with extended events and a view to look at the exceptions: http://www.sommarskog.se/Short%20Stories/trace-exceptions.html