SQL 2008R2 Maintenance Plan in a Master/Target Server Environment (MSX/TSX)

• Dave-993364

  SSC-Addicted

  Points: 483

  More actions

  June 11, 2013 at 4:45 am

  #278872

  Hi,

  I'm just triialling a situation to see if I can figure out if I can set this up in our SQL Server estate.

  We have > 180 SQL Servers to maintain, and was hoping I could set up 1 Master server to deploy all the SQ LAgent Jobs to all the remaining servers.

  There is a mix of SQL 2008R2, SQL 2008 and SQL 2005 (there are a couple of SQL 2000, but I can live with managing these individually).

  Anyway, I've recreated a basic set up on my laptop. The base install of SQL is SQL2008, then there are 3 more instances installed as well, a SQL 2005, SQL 2008 and SQL2008R2 instances.

  I can add a SQL agent job and it happily gets populated to all the instances and all seems fine.

  However, here's my problem. There was a maintenance plan already created for all the instances except the SQL2005 one.

  When I edit the maintenance plan, and add the instance to the list of servers to deploy to, it issues the message:

  "Apply to target server failed for job 'MaintenancePlan.Daily (Multi-Server)"

  I've tried creating a brand new Maintnenace Plan from scratch, using the Wizard and also manually, but still getthe same results.

  So, now my head is hurting from bashing it against the immovable wall in front of me. 🙂

  Could anyone help to get rid of this wall ?

  Thanks

  Dave