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.
Admin server can be changed for multiple items via the Admin Client in the Files view.
I hope this helps !
I hope this helps !
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
Database move process is also supposed to handle agent $MachineName assignment.
lots of options
http://www-10.lotus.com/ldd/sandbox.nsf/Search?SearchView&Query=ACL&SearchOrder=0&Start=1&Count=100