If I am going to just move the databases to a different server running the EXACT same version of ICM do I need to use EDMT? It has a new hostname, and it is different hardware, however its identical Versions... Any help as quick as possible appreciated. I was thinking that my normal install procedure far an AW / HDS and just restoring the DB's should be satisfactory, can someone confirm or deny this?
If everything is going to be the same and you are only moving the DB follow this plan.
The procedure for rebuilding HDS2 database would be the following.
1.) Backup HDS1 using SQL Enterprise Manager
2.) Copy the HDS1 database backup file to HDS2
3.) Shutdown ICM services on HDS2
4.) Using SQL Query Analyzer run sp_helpdb on HDS1 and
save the output which contains db size and file info.
6.) Using ICMDBA allocate a new HDS2 database the same size or larger
then the HDS1 database.
7.) Using SQL Enterprise Manager restore the HDS1 backup file to the new
8.) Truncate the Recovery and Logger_Admin tables in HDS2 database using
the following queries in SQL Query Analyzer.
truncate table Recovery
truncate table Logger_Admin
9.) Restart ICM Services.
No need for EDMT tool.