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