03-12-2009 05:18 PM - edited 03-14-2019 03:48 AM
Guys,
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?
Thanks!
Chad
Chad
Solved! Go to Solution.
03-13-2009 08:45 AM
Chad
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
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
HDS2 database.
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.
Joe
03-12-2009 07:53 PM
AFAIK you can just backup and restore the db's in the new location. The db is not aware of what server it is installed on. I've done something similar with a 7.2x upgrade before.
03-13-2009 08:45 AM
Chad
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
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
HDS2 database.
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.
Joe
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: