Database Maintainance Plan in Multiserver Environmentgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Is there any way I can setup "Database Maintainance Plan" in mulriserver environment, i.e. setup this plan on master server to perform backups, integrity, etc, on target servers. I've tried, but it didn't allow me to setup as multiserver job. I had to go to the job and change it to multiserver job by adding target server, but then job has failed. Thank you.
-- Anonymous, October 02, 2000
As far as I can tell, the Database Maintenance Plan Wizard allows you to set up maintenance on a server by server basis (that is, not multiserver). However (at least on the SQL Server 2000 - Beta 2 that I am using) you can keep the maintenance history on a remote server.
Hope this helps,
-- Anonymous, October 11, 2000