Table Of Contents
Video Administration Backup and Restore Procedures
Backup Procedure
Backing Up the Database
Backing Up Configuration Files
Database Connectivity Property File
Configuration Files
LDAP Configuration Files
Backing Up Branding and Sound Files
Restoring Procedure
Procedure Overview
Restoring the Database
Restoring Configuration Files
Restoring Branding and Sound Files
Restart the Video Administration Service
Video Administration Backup and Restore Procedures
This chapter provides procedures for backing up and restoring the Video Administration database and configuration files. See the following sections:
•
Backup Procedure
•Restoring Procedure
Backup Procedure
This section describes how to back up Video Administration data. See the following sections:
•Backing Up the Database
•Backing Up Configuration Files
•Backing Up Branding and Sound Files
Backing Up the Database
This section describes how to back up the Video Administration database using the Enterprise Manager utility that comes with Microsoft SQL Server 2000 Standard and Enterprise editions. The Microsoft SQL Server 2000 Desktop Edition (MSDE) installation does not come with the Enterprise Manager utility by default. For a database on an MSDE server, you need an external Microsoft SQL Enterprise Manager to connect to the MSDE server.
Note The external server with Microsoft SQL Enterprise Manager must be in the same subnet as the MSDE server for the backup procedure to be successful.
If you configured Video Administration to use Microsoft SQL Server 2000 Desktop Edition (MSDE) perform the following procedures:
•"To Connect To an MSDE Database Server" procedure
•"To Back Up the Database" procedure
If you configured Video Administration to use Microsoft SQL Server 2000 Standard Edition or Enterprise Edition, perform the following procedure:
•"To Back Up the Database" procedure
To Connect To an MSDE Database Server
Step 1 Open Microsoft SQL Enterprise Manager on a SQL 2000 Server.
Step 2 In Enterprise Manager, right-click SQL Server Group and select New SQL Server Registration. The Register SQL Server Wizard launches.
Step 3 Click Next. The Select a SQL Server page appears.
Step 4 From the list of Available Servers, select the name of the server that the Video Administration is installed on and click Add.
Step 5 Click Next. The Select an Authentication Mode page appears.
Step 6 Select the SQL Server Authentication radio button and click Next.
Step 7 Select the Login Automatically Using My SQL Server Account Information radio button.
Step 8 Enter the Login Name and Password that you created when you installed MSDE.
To Back Up the Database
Step 1 Open the Video Administration database by using the MSSQL Enterprise Manager. By default, the installed Video Administration database name is cisco_core_db and the default user name is cisco_core_user. The actual name of the database and user name is configurable during the installation process.
Step 2 In Enterprise Manager, under the server name that the Video Administration database resides, right-click Databases and select New Database. The Database Properties dialog box displays.
Step 3 Give the new database a name, for example cisco_core_db_new, and click OK.
Step 4 Right-click the cisco_core_db_new database, and select All Tasks > Import Data. This will launch the DTS Import/Export Wizard.
Step 5 In the Choose a Data Source dialog box:
–In the Data Source field, select Microsoft OLE DB Provider for SQL Server (default).
–Select the server from the list.
–Select the Use SQL Server Authentication radio button.
–Enter the username and password for cisco_core_db.
–Choose cisco_core_db as the database.
–Click Next.
Step 6 In the Choose a Destination dialog box, cisco_core_db_new should be selected by default as the database destination. Click Next.
Step 7 In the Specify Table Copy or Query dialog box, select the Copy Table(s) and View(s) From the Source Database radio button and click Next.
Step 8 In the Select Source Tables and Views dialog box, click Select All and then click Next.
Step 9 In the Save, Schedule, and Replicate Package dialog box, check the Run Immediately check box and click Next to run the import procedure.
Step 10 To generate an SQL script from the cisco_core_db database to reapply the relationship between tables, go to cisco_core_db database and select All Tasks > Generate SQL Script. The Generate SQL Scripts dialog box opens.
Step 11 On the General tab:
–Click the Show All button
–Check the Script All Objects check box.
Step 12 On the Formatting tab, uncheck all of the check boxes.
Step 13 On the Options tab:
–Uncheck the check boxes in the Security Scripting Options
–Check the check boxes in the Table Scripting Options
–Select the Windows Text (ANSI) radio button
–Select the Create One File radio button
–Click OK.
Step 14 In the Save As dialog box, give the script file a name that ends with .sql.
Step 15 Once the SQL script is created, open the script in a text editor and replace all instances of the string "[cisco_core_user]" with "[dbo]".
Note cisco_core_user is the database owner of the database cisco_core_db. The goal is to change the owner of the new cisco_core_db_new database to "dbo" so that this database can be restored on any external database.
Step 16 To run the script on cisco_core_db_new database, select the cisco_core_db_new database, and select the Tools > SQL Query Analyzer menu.
Step 17 In SQL Query Analyzer, open the script file you created in Step 14.
Step 18 Press F5 to apply the script to the database. You will see the following message in the Query Analyzer window:
The command(s) completed successfully.
Step 19 Close SQL Query Analyzer.
Step 20 Select and right-click the cisco_core_db_new database, and select All Tasks > Backup Database to create a database backup file.
Step 21 In the SQL Server Backup dialog box:
–Check the Database - Complete radio button (default).
–Click the Add button, select a file name for backup destination, and click OK.
–Click OK.
Backing Up Configuration Files
This section describes how to back up the following files by copying them to a different physical location:
•Database Connectivity Property File
•Configuration Files
•LDAP Configuration Files
Database Connectivity Property File
Back up the mssql-ds.xml file under the directory C:\Program Files\Cisco\Video Admin\VA\jboss-3.2.5\server\all\deploy to a different physical location.
Configuration Files
Back up the following files under the directory C:\Program Files\Cisco\Video Admin\VA\jboss-3.2.5\bin to a different physical location:
•vcs-cdr-config.xml
•vcs-config.xml
•vcs-core.properties
•vnex.properties
LDAP Configuration Files
Back up the following files under the directory C:\Program Files\Cisco\Video Admin\VA\jboss-3.2.5\bin\configFiles to a different physical location:
•All files (if any) under this directory.
Backing Up Branding and Sound Files
Back up all files (if any) located under the directory C:\Program Files\Cisco\Video Admin\VA\jboss-3.2.5\server\default\deploy\branding.war\image to a different physical location.
Restoring Procedure
This section describes how to restore Video Administration data. See the following sections:
•Procedure Overview
•Restoring the Database
•Restoring Configuration Files
•Restoring Branding and Sound Files
•Restart the Video Administration Service
Procedure Overview
The restoring procedure includes the following stages:
1. Stop the Video Administration service:
–Go to Control Panel > Administrative Tools > Services.
–Find the service named "Cisco Video Administration" and stop it.
2. Restore the database—see the "Restoring the Database" section.
3. Restore the configuration files—see the "Restoring Configuration Files" section.
4. Restore the Branding and Sound Files—see the "Restoring Branding and Sound Files" section.
5. Start the Video Administration service.
Restoring the Database
This section describes how to restore the Video Administration database using the MSSQL Enterprise Manager. Prior to restoring, you must have the Video Administration software installed. You will be restoring a backed up database into the existing database.
To Restore the Database
Step 1 Stop the Video Administration service:
–Go to Control Panel > Administrative Tools > Services.
–Find the service named "Cisco Video Administration" and stop it.
Step 2 Open the Video Administration Database by using the Microsoft SQL Enterprise Manager utility. The Microsoft SQL Server 2000 Desktop Edition (MSDE) installation does not come with Enterprise Manager by default. For a database on an MSDE server, you need an external Microsoft SQL Enterprise Manager to connect to the MSDE server.
Step 3 Select and right-click the clisco_core_db database and select All Tasks > Restore Database. The Restore Database dialog box opens.
Step 4 On the General tab:
–Select the From Device radio button
–Click the Select Devices button and browse to the MSSQL database backup file you created in the backup procedure.
–Select the Restore Backup Set and Database-Complete radio buttons.
Step 5 On the Options tab:
–Check the Force Restore Over Existing Database check box.
–Under the "Move to Physical File Name" column, make sure that the name of the data and log files are cisco_core_db.MDF and cisco_core_db_Log.LDF.
–Leave the values under the "Logic File Name" column untouched.
–Select the Leave Database Operational - No Additional Transaction Logs Can Be Restored radio button.
–Click OK.
The database is successfully restored.
Step 6 In the SQL server tree control, select Security > Logins and double-click the Video Administration database user (for example, cisco_core_user). The SQL Server Login Properties dialog box opens.
Step 7 On the Database Access tab:
–Under "Specify Which Databases Can Be Accessed by This Login," select the Permit check box for the Video Administration database (for example, cisco_core_db).
–Under "Database Roles for cisco_core_db," select Permit check box options for Public role and db_owner role.
–Click OK.
Step 8 On the General tab, make sure that the database name, user name, and password are the same that were used on the old database that you backed up. The specifics are indicated in mssql-ds.xml:
<connection-url>jdbc:microsoft:sqlserver://IP_address:1433;
databasename=cisco_core_db;SendStringParametersAsUnicode=
false</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.
SQLServerDriver</driver-class>
<user-name> cisco_core_user </user-name>
<password>...</password>
Restoring Configuration Files
Restore the configuration files listed in the "Backing Up Configuration Files" section.
Restoring Branding and Sound Files
Restore the files mentioned in the "Backing Up Branding and Sound Files" section.
Restart the Video Administration Service
To Restart the Video Administration service
Step 1 Go to Control Panel > Administrative Tools > Services.
Step 2 Find the service named "Cisco Video Administration" and start it.
