SQL Server Performance Forum – Threads Archive

Log Shopping Restore Job Failing

Hello. I setup log shipping to a remote server. The inital transfer and restore works but restore fails each time after that and does not give any error info other than ‘failed.’ Any thoughts what could be causing this?

---

Did you leave the resored database in a condition to receive furtherlog restores? i.e. didn’t recover it. Are you missing some logs? Think they would botyh give a message though. Any non-logged ops on the source. This happened to me when the database was on dodgy disks. Every time there was a write error (not enough to cause apparent problems on the source) the log restore would fail. That was every couple of days.

---

maybe you can try this article:
http://www.sql-server-performance.com/sql_server_log_shipping.asp to make sure all the requirements are there in order for your log shipping process to be worked out successfully.

---

Also chekc MDAC tools and similar levels of SP/Hotfixes in this case. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

---

I checked all of that. The next thing I’m going to try is to completely delete the copy of the database from the standby server and let Log Shipping create, backup and restore and see if that works.

---

I mever use microsofts log shipping but do the backuos, transfers and restores via stored procs. Gives you more control over what is happening. See
http://www.nigelrivett.net/SQLAdmin/LogShipping.html

---

]]>