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