moonshadow
Programmer
We have a SQL server 7 box we're using as a master server to administer 116 other SQL Servers (SQL 2000). We want to transfer control to a new SQL 2000 master server. Currently I'm thinking of scripting all the jobs, defecting all the servers, re-enlisting them on the new server, then running the scripts to set up the jobs. Two questions:
1) is there an easier way?
2) Will the old jobs dissappear, be replaced by the 'new' jobs, or will we have to delete them manually?
1) is there an easier way?
2) Will the old jobs dissappear, be replaced by the 'new' jobs, or will we have to delete them manually?