Multi Server Management

[jake29]

Is anybody using this in a SQL2005/Win2003 multi-domain config? I am looking to roll out and run maintenance plan jobs on 15+ stand alone servers on minimum budget. The plans are basic backups and DBCC and this seems like the way to go. I have been though the BOL and manage to connect two servers in a test environment. One issue off the top is that Jobs that are pushed over error and are looking for the Maintenance Plans stored procedure.

I guess I am looking for some feedback from those that have already have this going.

Thanks,

Jake

 

[mrdenny]

The jobs will be pushed, but the maint plan won't be. You'll still have to manually push the maint plan to each server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[jake29]

Thank you.
I know this may seem lazy but by manually push, what do you mean. Create them on each server?