SQL Server Performance

log shipping problem copying

Discussion in 'SQL Server Log Shipping' started by Mthorn, Jan 31, 2007.

  1. Mthorn New Member

    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
  2. MohammedU New Member

    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
  3. zvidas New Member

    http://support.microsoft.com/kb/314515
  4. Mthorn New Member

    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?
  5. MohammedU New Member

    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
  6. satya Moderator

    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.
  7. Mthorn New Member

    select @@servername on both servers returns the correct value

Share This Page