migrating HDS wvdb and AW

Answered Question
Mar 12th, 2009

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

Correct Answer by joesnyde about 7 years 11 months ago

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 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

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Edward Umansky Thu, 03/12/2009 - 19:53

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.

Correct Answer
joesnyde Fri, 03/13/2009 - 08:45

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 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

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

Actions

This Discussion