SQL Server Performance

Log shipping setup error

Discussion in 'SQL Server 2005 Log Shipping' started by datosiva, Dec 23, 2009.

  1. datosiva New Member

    Dear Seniors/Experts
    I configured the log shipping in sql 2005 from production server to a dr server. Configuration went smoothly. All the LS jobs created successfully.
    LSBackup at production machine and LSCopy and LSRestore at DR machine.
    LSBackup run successfully at prod server and trn log has been generated but at DR site the LSCopy and LSRestore failed with below error.
    Please assist me to solve this:
    *** Error: Could not retrieve copy settings for secondary ID '393f37f6-1228-482e-b4bf-7da1d17b06f3'.(Microsoft.SqlServer.Management.LogShipping) ***
    2009-12-23 16:45:00.64 *** Error: The specified agent_id 393F37F6-1228-482E-B4BF-7DA1D17B06F3 or agent_type 1 do not form a valid pair for log shipping monitoring processing.(.Net SqlClien)
  2. ghemant Moderator

Share This Page