Post reply

Apply to target server failed for job

  • November 3, 2008 at 10:42 am

    #214809

    I got this error msg when trying to save a new Maintenance Plans ( backup databases) using Design mode. I googled the problem but couldnt find any solution. Please help. Thank you very much

    Regards

    Nick

  • November 4, 2008 at 4:51 am

    #893531

    Have you confirmed that SQL Agent service is running? And please also tell that either you are using wizard or designer for creating the plan?

    DBDigger Microsoft Data Platform Consultancy.

  • November 4, 2008 at 10:08 am

    #893739

    Yes, the sql Agent is running. I used the designer.

    Thanks

  • November 4, 2008 at 10:27 am

    #893756

    What's the edition and service pack of the sql server?

    _____________
    Donn Policarpio

  • November 4, 2008 at 11:13 am

    #893776

    Enterprise

    Version 9.00 3042.00

    I guess it's SP2

  • November 4, 2008 at 1:02 pm

    #893844

    And this is not applying a Maint. Plan to a MASTER server or a TARGET server right?

    which are part of the multiserver environment

    http://msdn.microsoft.com/en-us/library/bb153887(SQL.90).aspx

    You can create a multiserver maintenance plan using the Maintenance Plan Wizard, or you can use the design surface. The Wizard is best for creating basic maintenance plans, while creating a plan using the design surface allows you to utilize enhanced workflow.

    To create a multiserver maintenance plan, a multiserver environment containing one master server and one or more target servers must be configured. Multiserver maintenance plans must be created and maintained on the master server. These plans can be viewed, but not maintained, on target servers.

    it's a stand-alone server?

    9.0.3042 = 2005 SP2 yes

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • November 4, 2008 at 3:05 pm

    #893923

    Dear Jerry Hung

    Yes it's a stand alone server

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply