Sekar Chinnakannu
asked on
ADMT Database move to new server. Need help to know the steps to perform pre and post check.
ADMT Database move to new server. Need help to know the steps to perform pre and post check.
Need help on basic sql queries to check the status\data on the ADMT DB too.
Need help on basic sql queries to check the status\data on the ADMT DB too.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
all we are doing is moving the DB from A to B location no other changes, I am trying to understand what check i need to do here.
Just curious, why are you moving ADMT from one server to another? ADMT is usually a temporary (temporary DC if you want to use ADMT command line) server implemented and used during a migration.
ASKER
Currently we have ADMT 3.2 version installed on our environment, I am planning to detach DB from SQL from A location and uninstall the ADMT tool. Once DB is attached to B location install ADMT tool with same DB. Hope this should work as expected.
ASKER
It worked.
ASKER
It's a full sql server, Could you please help me to get some basic queries to validate before and after the migration in ADMT DB.