SQL Server Performance

LS copy fails randomly

Discussion in 'SQL Server Log Shipping' started by rajeshraghavan, Oct 12, 2006.

  1. rajeshraghavan New Member

    Hi All,
    The log shipping copy fails randomly but it automatically corrects itself in the next copy cycle. I looked at the Windows eventlogs and SQL Server Error Logs it just sqlmaint.exe failed doesn't give much info at all. Does somebody know why is this happening.

    Thanks in advance
    Rajesh
  2. satya Moderator

    Can you check the reference maintenance plan log file in this case, if there are no log records to restore then you tend to see such information.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page