log shipping problem copying | SQL Server Performance Forums

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?
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.

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..
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
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