SQL Server Performance Forum – Threads Archive

log shipping problem copying

I’ve set up log shipping between two trusted servers and the copy job is not working. If I manually copy the logs over the restore picks them up and applies them. I’m guessing it’s some sort of permission issue but I can’t seem to get it to work. Has anyone had this problem and know how to fix this?
thanks

---

Are you able run windows commands using xp-cmdshell from QA…
Is sql service account is domain account? Ex: exec master..xp-cmdshell ‘dir \destServerc$’ MohammedU.
Moderator
SQL-Server-Performance.com

---

http://support.microsoft.com/kb/314515

---

sorry for the delay in replying to this post. I found that the source_destination in the log_shipping_primaries was defaulting to NULL. When I updated this column to reflect the correct destination it worked. Any ideas why this would default to NULL?

---

Just a guess…
SELECT @@SERVERNAME might be returning the NULL, so run SELECT @@SERVERNAME on both servers and see what you get..
MohammedU.
Moderator
SQL-Server-Performance.com

---

IF the servername is NULL I would guess the Log shipping may not be able to setup. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

select @@servername on both servers returns the correct value

---

]]>