SQL Server Performance

Log Shipping Error

Discussion in 'SQL Server Log Shipping' started by subhashs, Jun 13, 2008.

  1. subhashs New Member

    I have created a log shipping between two server.
    1.Production Server : Act As Primary Server
    2.Backup Server: Act as Secondary Server.
    Primary Server having the maintaince plan . on primary Server all jobs are get successful but on Secondary Server one Job fails : populated the error like
    Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
    If any one know why this is happen kindly give some guidlines regarding this. Thanks
  2. ghemant Moderator

    Hi Subhash,
    We will need more information to help you, lilke
    what this job does!!
    SQL Server sp level!!
    What exactly the error is!!
    You need to dig more for the details, see if you have any
    1. specific error loged in SQL Error log!
    2. refer Job History for that particular job of maintenance plan!
    3. in adition to that refer windows error log too!
    see if these link helps you http://support.microsoft.com/kb/326485 & http://support.microsoft.com/kb/288577
    and post back your findings

Share This Page