Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

migrating HDS wvdb and AW

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

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: migrating HDS wvdb and AW

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

2 REPLIES

Re: migrating HDS wvdb and AW

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.

Cisco Employee

Re: migrating HDS wvdb and AW

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

264
Views
0
Helpful
2
Replies