Table Of Contents

Backing up and Restoring Cisco Unified Videoconferencing Manager Data

Overview

How to Back up Cisco Unified Videoconferencing Manager Data

Backing Up the Internal Database

Backing Up an MSSQL 2005/2000/MSDE Database

Back-up File Locations for Configuration Files

Database Connectivity Property File

Configuration Files

LDAP Configuration Files

Network Manager Configuration Files

OCS 2007 Connector Files

Backing Up Branding and Sound Files

Backing Up the License

How to Restore Cisco Unified Videoconferencing Manager Data

Restoring Configurations

Restoring the Internal Database

Restoring an MSSQL 2005/2000/MSDE Database

Restoring Configuration Files

Restoring to a Different Server

Restoring OCS 2007 Connector Files

Restoring Branding and Sound Files

Restoring the License

Backing up and Restoring Cisco Unified Videoconferencing Manager Data

---

You can back up and restore the Cisco Unified Videoconferencing Manager database and configuration files.

Only backup and restore of the database and configuration files within the same Cisco Unified Videoconferencing Manager version is supported. Do not attempt to backup the database and configuration files from an old Cisco Unified Videoconferencing Manager version and restore these files to a newer version.

•Overview

•How to Back up Cisco Unified Videoconferencing Manager Data

•How to Restore Cisco Unified Videoconferencing Manager Data

Overview

There are many reasons for performing system backups on a regular basis, such as:

•Hardware failure

•Software failure

•Data corruption

•User mistakes

•Before any software upgrade

To restore Cisco Unified Videoconferencing Manager data, stop the Cisco Unified Videoconferencing Manager service before restoring the database, configuration files, branding and sound files. Restart the Cisco Unified Videoconferencing Manager service after restoration is complete.

How to Back up Cisco Unified Videoconferencing Manager Data

•Backing Up the Internal Database

•Backing Up an MSSQL 2005/2000/MSDE Database

•Back-up File Locations for Configuration Files

•Backing Up Branding and Sound Files

•Backing Up the License

Backing Up the Internal Database

Procedure

---

Step 1 Open a DOS window and go to the MySQL bin directory located by default at one of the following locations:

C:\Program Files\MySQl\mysql-4.0.21-win\bin, or

C:\MySQl\mysql-4.0.21-win\bin

Step 2 Run the following DOS command to export the contents of the internal database to a file called mydump:

mysqldump -u root --all-databases --add-drop-table --single-transaction > mydump

Step 3 Save the mydump file to a safe location.

---

Backing Up an MSSQL 2005/2000/MSDE Database

This section is only relevant if your Cisco Unified Videoconferencing Manager installation is using an external MSSQL database. For demonstration purposes, we assume the installed Cisco Unified Videoconferencing Manager database name is "temp_db" and that the database owner is "temp_user".

You can modify the database name and its owner name during the installation process.

Procedure

---

Step 1 Use Microsoft SQL Server Enterprise Manager or Microsoft SQL Server Enterprise Manager Management Studio to access temp_db.

MSDE database does not include a management console by default. You need to use an external management console to connect to a MSDE database.

Step 2 Right-click temp _db and select All Tasks > Backup Database, or Task > Backup to create a database backup file.

Assume the name of the backup file is "temp_db.bak".

Step 3 Save temp_db.bak to a safe location.

---

Back-up File Locations for Configuration Files

This section describes how to back up the following files by copying them to a safe physical location.

•Database Connectivity Property File

•Configuration Files

•LDAP Configuration Files

•Network Manager Configuration Files

•OCS 2007 Connector Files

Database Connectivity Property File

For Cisco Unified Videoconferencing Manager version 5.5 or later—Place the following files under C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\default\deploy

For Cisco Unified Videoconferencing Manager version 5.1 or earlier—Place the following files under C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\all\deploy

•mssql-ds.xml (when working with Microsoft SQL server)

•mysql-ds.xml (when working with the internal database server)

Configuration Files

Backup the following configuration files from C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\bin:

vcs-cdr-config.xml

vsc-config.xml

vcs-core.properties

vnex.properties

LDAP Configuration Files

Place the following files under the C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\bin\configFiles directory:

•All files (if any) under this directory.

Network Manager Configuration Files

For Cisco Unified Videoconferencing Manager version 5.5 or later—Place the following under C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\default\deploy\
vcs.ear\nms.war\WEB-INF\classes

For Cisco Unified Videoconferencing Manager version 5.1 or earlier—Place the following under C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\all\deploy\
vcs.ear\nms.war\WEB-INF\classes

•adminconfig folder

•config folder

OCS 2007 Connector Files

Cisco Unified Videoconferencing Manager version 5.6 or later supports OCS 2007. Back up the following files:

•ICM_HOME\jboss\server\default\deploy\vcs.ear\ocs.war\jsp\oc\tab.xml

•ICM_HOME\sipserver\conf\SIPConfig.xml

where ICM_HOME is the Cisco Unified Videoconferencing Manager installation directory.

By default, ICM_HOME is C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM

Backing Up Branding and Sound Files

For Cisco Unified Videoconferencing Manager version 5.5 or later—Back up all files (if any) located under C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\default\
deploy\branding.war\image.

For Cisco Unified Videoconferencing Manager version 5.1 or earlier—Back up all files (if any) located under C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM\jboss\server\all\
deploy\branding.war\image.

Backing Up the License

Procedure

---

Step 1 Go to Start > Run and enter regedit to open the Windows registry.

Step 2 For Cisco Unified Videoconferencing Manager version 5.5 or later—Back up the license key under:

\HKEY_LCOAL_MACHINE\SOFTWARE\CISCO > RESOURCE MANAGER\4.0

Step 3 For Cisco Unified Videoconferencing Manager version 5.1 or earlier—Back up the license and serial number under:

\HKEY_LCOAL_MACHINE\SOFTWARE\CISCO > RESOURCE MANAGER > license

\HKEY_LCOAL_MACHINE\SOFTWARE\CISCO > RESOURCE MANAGER > serial

---

How to Restore Cisco Unified Videoconferencing Manager Data

•Restoring Configurations

•Restoring the Internal Database

•Restoring an MSSQL 2005/2000/MSDE Database

•Restoring Configuration Files

•Restoring Branding and Sound Files

•Restoring the License

Restoring Configurations

Procedure

---

Step 1 Stop the Cisco Unified Videoconferencing Manager service

•Go to Control Panel > Administrative Tools > Services.

•Locate the service named "Cisco Unified Videoconferencing Manager" and stop it.

Step 2 Restore the database—see the"Restoring the Internal Database" section.

Step 3 Restore the configuration files—see the"Restoring Configurations" section.

Step 4 Restore the Branding and Sound Files—see the"Restoring Branding and Sound Files" section.

Step 5 Restore the License Files—see the"Restoring the License" section.

Step 6 Start the Cisco Unified Videoconferencing Manager service.

---

Restoring the Internal Database

Procedure

---

Step 1 Open a DOS window and go to the MySQL bin directory located by default at one of the following locations:

C:\Program Files\MySQl\mysql-4.0.21-win\bin

or

C:\MySQl\mysql-4.0.21-win\bin

Step 2 Copy the mydump file to the bin directory where mydump is the name of the database backup file.

Step 3 In the DOS window, enter the "mysql -u root" command to access the MySQL database command line user interface.

The command link prompt changes to mysql>.

Step 4 Run the following command to restore the content that has been dumped into the backup file to the database:

mysql> source mydump

Step 5 Run the following command to exit the MySQL command line window:

mysql > exit

---

Restoring an MSSQL 2005/2000/MSDE Database

This section is only relevant if your Cisco Unified Videoconferencing Manager installation is using an external MSSQL database. For demonstration purposes, we assume the installed Cisco Unified Videoconferencing Manager database name is "temp_db" and that the database owner is "temp_user".

You can modify the database name and its owner name during the installation process.

Procedure

---

Step 1 Use Microsoft SQL Server Enterprise Manager or Microsoft SQL Server Enterprise Manager Management Studio to access temp_db.

MSDE database does not include a management console by default. You need to use an external management console to connect to a MSDE database.

Step 2 If you are restoring temp_db to the same database server, make sure that temp_db exists.

If "temp_db does not exist, create a new database called temp_db.

Step 3 If you are restoring temp_db to a new database server, delete the temp_db database on that new database server if it exists, and create a new database called temp_db.

Step 4 Ensure no other applications are using temp_db.

Step 5 Right-click temp _db and select All Tasks > Restore Database, or Task > Restore > Database.

Step 6 Select From device on the General tab, and use the temp_db.bak as the backup file.

Step 7 Click Options.

Step 8 Select either Force restore over existing database or Overwrite the existing database.

Step 9 Click OK.

Step 10 Select temp_db and open the Query Analyzer window.

Step 11 From the Query Analyzer, run

sp_helpuser 'temp_user' 

where temp_user is the name of the database user.

The database restore procedure has succeeded if the LoginName entry is the same as the UserName entry in the returned table, and if the DefDBName entry is temp_db.

Step 12 If the LoginName and DefDBName entries are null:

a. Run

sp_addlogin 'temp_user', 'temp_user_password', 'temp_db', null, [SID value from 
the table returned at 11]

where

"temp_user" is the name of the database user

"temp_db" is the name of the database

"temp_user_password" is the database user password. Its value should be the same as the "temp_user" password from the old backup database.

You can create a new password if you wish. Update the new password in the mssql-ds.xml file in clear text, as shown below. The old password is stored in encrypted format.

<connection-url>jdbc:microsoft:sqlserver://IP_address:1433;databasename=temp_db;

	SendStringParametersAsUnicode=false</connection-url>

	<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>

	<user-name>temp_user</user-name>

	<password>temp_user_password</password>

b. Run

sp_helpuser 'temp_user' 

and verify that the LoginName entry is the same as the UserName entry in the returned table, and that the DefDBName entry is temp_db.

---

Restoring Configuration Files

Copy the configuration files listed in the "Back-up File Locations for Configuration Files" section back to their appropriate directory.

•Restoring to a Different Server

•Restoring OCS 2007 Connector Files

Restoring to a Different Server

When restoring backup configuration files to a different server, verify that the server name in the <host-url> tag of the vcs-config.xml file is consistent with the current server name. For example:

<host-url>http://new-server-name:8080</host-url>

Restoring OCS 2007 Connector Files

When restoring the following files:

•ICM_HOME\jboss\server\default\deploy\vcs.ear\ocs.war\jsp\oc\tab.xml

•ICM_HOME\sipserver\conf\SIPConfig.xml

where ICM_HOME is the Cisco Unified Videoconferencing Manager installation directory,

remove the following file if it exists:

•ICM_HOME\sipserver\conf\UpdatedSIPConfig.xml

By default, ICM_HOME is C:\Program Files\Cisco\Unified Videoconferencing Manager\CUVCMRM

Restoring Branding and Sound Files

Copy the configuration files listed in the "Backing Up Branding and Sound Files" section back to their appropriate directory.

Restoring the License

Procedure

---

Step 1 Go to Start > All Programs > Cisco Unified Videoconferencing Manager > Update License.

Step 2 For Cisco Unified Videoconferencing Manager version 5.5 or later—Enter the backup license key in the Enter License field.

Step 3 For Cisco Unified Videoconferencing Manager version 5.1 or earlier—Enter the backup license key and serial number in the New license key and New serial number fields.

---