Link to home
Start Free TrialLog in
Avatar of Kat A
Kat A

asked on

Script needed for a major database move project

We're moving a few hundred databases from one server to another.  Does anyone have any script that will assign the new server as the administration server and remove the old server from each of the databases involved?  Also, need script that will update the ACL on the new server w/appropriate groups and roles.  
Avatar of SysExpert
SysExpert
Flag of Israel image

Admin server can be changed for multiple items via the Admin Client in the Files view.

I hope this helps !
ASKER CERTIFIED SOLUTION
Avatar of qwaletee
qwaletee

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I agree with qwaletee, I would use the built-in process. One other thing to consider is scheduled agents in any of these databases. Sometimes the servers are listed explicily in the schedule properteis and this will cause the agent to fail if it is not changed.
Avatar of qwaletee
qwaletee

Database move process is also supposed to handle agent $MachineName assignment.