Database Maintainance Plan in Multiserver Environment

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

Albert

-- Anonymous, October 02, 2000

Answers

Albert,

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,

Eric

-- Anonymous, October 11, 2000


Moderation questions? read the FAQ