Configuration Guide for Cisco Unified MeetingPlace Release 8.5
Configuring the SQL Server for the Web Server
Downloads: This chapterpdf (PDF - 210.0KB) | Feedback

Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server

Table Of Contents

Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server

Accessing Information on the SQL Server Database

How to Create and Use a Least-Privileged SQL Account for the Web Server

Creating a Least-Privileged SQL Account for the Web Server

Updating SQL Account Access from the MeetingPlace Gateway Configurations Utility

Restoring the Cisco Unified MeetingPlace Web Server After Boot Failure

How to Manage the SQL Database Size

Modifying the SQL Database Properties to Manage Database Size

Examples: Modifying the SQL Database Properties to Manage Database Size

How to Back Up and Restore MPWEB SQL Database

Creating a Backup File by Exporting the MPWEB Database

Creating a Full Backup of the Web Server

Restoring the Database

How to Detach and Attach the MPWEB SQL Database

Detaching the Database

Examples: Detaching the Database

Attaching the Database

Examples: Attaching the Database

How to Replace a Cisco Unified MeetingPlace Web Server and Retain the SQL Database

Preparing the Current Cisco Unified MeetingPlace Web Server

Installing the Replacement Cisco Unified MeetingPlace Web Server

Building the Replacement Cisco Unified MeetingPlace Web Server

Updating the Indices on the SQL Database

How to Use a Custom TCP Port for the SQL Server Connection

Customizing the SQL Port for the Local SQL Database

Customizing the SQL Port for the Remote SQL Database

Switching from the Local Database to the Remote Database on the Custom Port

Relocating the Database


Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server


Release 8.5
Revised: January 11, 2013 10:46 am


Note This topic does not apply to deployments in which users schedule meetings from the Cisco WebEx site. For information about Cisco WebEx integration deployments, see the Planning Guide for Cisco Unified MeetingPlace at http://www.cisco.com/en/US/products/sw/ps5664/ps5669/
products_implementation_design_guides_list.html
.



Note The SQL commands and operations described in this section are provided only for your convenience and should not be treated as definitive reference. For additional details about these commands and operations, search the Microsoft Knowledgebase or download the free Microsoft SQL Server 2008 Express Online Help package from Microsoft.


Accessing Information on the SQL Server Database

How to Create and Use a Least-Privileged SQL Account for the Web Server

Restoring the Cisco Unified MeetingPlace Web Server After Boot Failure

How to Manage the SQL Database Size

How to Back Up and Restore MPWEB SQL Database

How to Detach and Attach the MPWEB SQL Database

How to Replace a Cisco Unified MeetingPlace Web Server and Retain the SQL Database

Updating the Indices on the SQL Database

How to Use a Custom TCP Port for the SQL Server Connection

Relocating the Database

Accessing Information on the SQL Server Database


Note MPDBUser and MPDBAdmin are service accounts used by the SQL database application on the MPweb server for normal application operation. These accounts are not available for use by users or administrators.


Use the Database administration page to access information on the SQL Server database.

Before You Begin

If you are using a remote SQL server, make sure that the time on SQL server is synchronized with the Cisco Unified MeetingPlace Application Server and Web Server.

Procedure


Step 1 Sign in to the Cisco Unified MeetingPlace web user portal.

Step 2 Select Admin.

Step 3 Select Database.

Step 4 Select a database command.

Step 5 Select Submit.


How to Create and Use a Least-Privileged SQL Account for the Web Server

By default, the Cisco Unified MeetingPlace Web Server software installer suggests using the SQL built-in sa administrator account as the SQL Server user name. Often, a strong password for the sa account is sufficiently secure to protect your system from unauthorized access. However, if you do not want to continue to use a SQL account that has full administration rights after the installation is complete, you can create a SQL account with minimal privileges that is dedicated for use withCisco Unified MeetingPlace, and configure the Web Server to use this account.

Complete the following procedures in the order shown to create and use a least-privileged SQL account:

Creating a Least-Privileged SQL Account for the Web Server

Updating SQL Account Access from the MeetingPlace Gateway Configurations Utility

Creating a Least-Privileged SQL Account for the Web Server


Caution If you choose to create a SQL account that is dedicated for use with Cisco Unified MeetingPlace, ensure that it meets all the specified database role requirements in this procedure. Failure to do so can cause a database connection failure between the Web Server software and the SQL Server and result in a total outage or broken features.


Note If Cisco TAC determines that your SQL account does not meet requirements, you will be asked to reconfigure your SQL account and to delete any existing Cisco Unified MeetingPlace Web Server software database so that a new database can be created once the account problem is remedied.


Procedure


Step 1 Open the SQL Server Enterprise Manager and create a new login:

a. On the Start menu, select All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.

b. Select a server group to expand it, then select the name of a server.

c. Right click Security > Logins and select New Login.

The SQL Server Login Properties window displays.

Step 2 Enter a name for the login on the General tab.

Step 3 Select SQL Server Authentication.

Step 4 Enter a password for the account.

Step 5 Select MPWEB from the Database drop-down menu to set the MPWEB database as the default database.

Step 6 Select the Mappings tab.

Step 7 Specify the database roles for the MPWEB database:

a. Check the MPWEB database in the Databases table.

b. Check the boxes for the following roles in the Database Roles table:

db_datareader

db_datawriter

db_ddladmin

Step 8 Repeat Step 7 for each additional MPWEB slave database.

The slave databases have names that begin with "MPWEB_". Depending on your deployment, your SQL Server will have either one or two slave databases.

Step 9 Select OK to complete the account configuration.


Updating SQL Account Access from the MeetingPlace Gateway Configurations Utility

The MeetingPlace Gateway Configurations utility allows you to update the Web Server with the least-privileged SQL login account that you have already created. It does not create a SQL Server login or update the SQL Server for you.

Before You Begin

Change the username and password on SQL Server. See the "Creating a Least-Privileged SQL Account for the Web Server" section for instructions.

Procedure


Step 1 Stop the Cisco Unified MeetingPlace Web Master Service.

Step 2 Open the MeetingPlace Gateway Configurations utility.

Step 3 Select the Web Server tab.

Step 4 Enter the hostname or IP address of the SQL Server that you want to update in the Server field.

Enter local for a local server.

Step 5 Enter the username and password that you applied to the SQL Server.

Step 6 Select OK.

Step 7 Start the Cisco Unified MeetingPlace Web Master Service.


Related Topics

Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service module

Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager module

Restoring the Cisco Unified MeetingPlace Web Server After Boot Failure

Information in the Cisco Unified MeetingPlace Web Server software SQL database is replicated from the Cisco Unified MeetingPlace Application Server. As changes occur in the Application Server database, the SQL database is updated in real-time.

Each time the Web Server boots up, it compares the Application Server hostname that it has stored in the SQL database with that configured in the Gateway SIM. If the hostnames match, any changes that occur in the Application Server database are replicated to the SQL database in real-time.

If the hostnames do not match, the Web Server will consider the Application Server to have changed and fail to boot up.


Note The hostname in the SQL database is the value you entered when you installed the Web Server software.


Before You Begin

Complete this procedure if you cannot start the Cisco Unified MeetingPlace Web Server because you changed the value of the hostname in the Gateway SIM.

Restrictions

This procedure is strictly limited to the situation where the database on the Cisco Unified MeetingPlace Application Server is the same as the database on the Cisco Unified MeetingPlace Web Server.


Caution Misuse of this procedure in any other situations will cause database corruption and subsequent Cisco Unified MeetingPlace Web Server software functional failures.

Procedure


Step 1 Stop the Cisco Unified MeetingPlace Web Master Service.

Step 2 Verify that all Cisco Unified MeetingPlace services are shut down on the Web Server, including the IIS Admin Service and WWW Publishing Service.

Step 3 Open Enterprise Manager and navigate to the \Databases folder.

Step 4 Select and expand the MPWEB database.

Step 5 Select Tables from the left pane.

Step 6 Right-click dbo.System in the right pane.

Step 7 Select Edit Top 200 Rows.

Step 8 Change the value in the HostName column to the desired value.

Step 9 Start the Cisco Unified MeetingPlace Web Master Service or reboot the server.


Related Topics

If the hostnames on the SQL Server and the Gateway SIM do not match because the Application Server has changed, see Changing the Cisco Unified MeetingPlace Application Server Connection Configured in the Gateway SIM in the Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server module.

Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service module

How to Manage the SQL Database Size

Modifying the SQL Database Properties to Manage Database Size

Examples: Modifying the SQL Database Properties to Manage Database Size

Modifying the SQL Database Properties to Manage Database Size

The MPWEB database that the Cisco Unified MeetingPlace Web Server software creates is comprised of two files: MPWEB.mdf and MPWEB.ldf. The MDF file contains the actual data, while the LDF contains changes (both the content and timing) made to that data.

On a SQL server that has been actively and properly managed through regular database backup, this LDF file (also called Transaction Log) remains a reasonable size. However, if the SQL database has not been backed up in a while, this transaction log may become very large.

To help prevent the file from growing too large, configure the following three properties for the MPWEB database:

Recovery = Simple

Torn Page Detection = On

Auto Shrink = On


Caution This procedure applies only to the MPWEB database. Do not apply this procedure to any MPWEB slave database (these databases have names that begin with "MPWEB_").

Procedure


Step 1 Open a DOS command window.

Step 2 Sign in to the SQL Server by entering C:\osql -U userid -P password, replacing userid and password with the applicable value.

Step 3 See the current properties of the database.

a. Enter sp_helpdb MPWEB.

b. Enter go.

Step 4 Modify properties.

a. Enter alter database mpweb set auto_shrink on, recovery simple, torn_page_detection on.

b. Enter go.

Step 5 If you are low on disk space because the database file is already large, force an immediate database shrink and remove empty space in the database files by entering dbcc shrinkdatabase ('mpweb', percent). where percent is the amount of free space that you want to allow.


Related Topics

Examples: Modifying the SQL Database Properties to Manage Database Size

Examples: Modifying the SQL Database Properties to Manage Database Size

In the following examples, the output is displayed for each command that is used in the "How to Manage the SQL Database Size" section.

Sample Output for Viewing Current Database Properties

In this example, Recovery Mode is set to FULL and Torn Page Detection and Auto Shrink are not configured on this database.

1> sp_helpdb MPWEB
2> go
name         db_size       owner        dbid    created         status  
compatibility_level
MPWEB    1254.00 MB    sa           5       Oct 16 2003
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52,
IsAutoCreateStatistics, IsAutoUpdateStatistics

Sample Output for Modifying Database Properties

1> alter database mpweb set auto_shrink on, recovery simple, torn_page_detection on
2> go
1> sp_helpdb MPWEB
2> go
name         db_size       owner        dbid    created         status   
compatibility_level
MPWEB   1254.00 MB    sa            5       Oct 16 2003
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE,
Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoShrink,
IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics

Sample Output for Decreasing File Size

In this example, the size of the files are decreased in the MPWEB database to allow 10 percent free space in the files of MPWEB.

1> dbcc shrinkdatabase ('mpweb', 10)
2> go
DbId   FileId CurrentSize MinimumSize UsedPages   EstimatedPages
 ------ ------ ----------- ----------- ----------- --------------
      5      2        2912        1280        2912           1280
(1 row affected)
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.

Related Topics

How to Manage the SQL Database Size

How to Back Up and Restore MPWEB SQL Database

Complete the following procedures in the order shown to back up and restore the MPWEB database:

Creating a Backup File by Exporting the MPWEB Database

Restoring the Database

Creating a Backup File by Exporting the MPWEB Database

This backup file can be restored only on a SQL Server 2008 with equivalent or later service pack installed.

Procedure


Step 1 Export the MPWEB database.

To export the MPWEB database to create a backup copy while the Cisco Unified MeetingPlace Web Master Service is running (as part of a daily backup procedure, for example), proceed to Step 2.

or

To export the MPWEB database so that it can be imported on another SQL Server that can continue operations for this Cisco Unified MeetingPlace Web Server, stop the Cisco Unified MeetingPlace Web Master Service and wait for all of the Cisco Unified MeetingPlace services, IIS Admin service, and World Wide Web publishing service to stop.

Step 2 Access the SQL Server.

If the SQL Server that hosts the MPWEB database runs on a separate (remote) Windows server, locate that Windows server and sign in.

or

If the SQL Server that hosts the MPWEB database runs on the Cisco Unified MeetingPlace Web Server, log in to that server.


Note If SQL Server runs on separate (remote) Windows server and you cannot sign in to that separate (remote) Windows server, then sign in to any Windows-based workstation or server on the network that has a valid installation of SQL Server Management Studio, so you can connect remotely to the SQL Server.


Step 3 Connect to SQL Server by using SQL Server Management Studio.

Select Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.

If the SQL Server runs locally, select the local MPWEBSQL server name and use Windows Authentication.

If the SQL Server runs remotely, select Browse and choose the appropriate server name and authentication.

Step 4 Navigate to the \Databases folder to verify that the MPWEB database exists on the server.

Step 5 Export the database.

a. Right-click the MPWEB database and select Tasks > Back Up.

b. Select MPWEB as the Source Database.

c. Select Full for Backup Type.

d. Enter a Backup set "Name" and "Description".

e. Select the "Backup set expiration" After and enter the number of days or On and enter a date.


Note Zero days means no expiration.


f. Select Disk for Destination.

g. Select MPWEB.bak in the Destination list if this backup file already exists.

If this is the first backup, select Add and browse to a backup File name or select a Backup device.

h. Select OK to start the backup.

When the backup completes successfully, the message "The backup of database `MPWEB' completed successfully." displays.

Step 6 Close SQL Server Management Studio.

Step 7 Save the mpweb.dat file in a safe location, for example, on a tape or network drive on another server.

If you migrated from a previous release, then also save your mpweb_XX.dat files in a safe location.


What to Do Next

Proceed to the "Restoring the Database" section.

Creating a Full Backup of the Web Server

Procedure


Step 1 Make a copy of the entire \MPWEB\Meetings folder and its contents.

Step 2 Make a copy of the GUIDS.reg file.

You can find this file where the Cisco Unified MeetingPlace Web Server software files are stored. For example, c:\Program Files\Cisco Systems\MPWeb.

Step 3 Open regedit and obtain the registry values for GUIDWebID and DBName.


Caution Ensure that the registry values are correct. Compare the values that you obtained in Step 3 against what you enter in Step 4.

Step 4 Open GUIDS.reg in a text editor and add the GUIDWebID and DBName registry paths and key values.

Step 5 Save the file with these changes.

Step 6 Make a backup of the MPWEB database and the mpweb slave database(s).

Step 7 Copy the GUIDS.reg and the MPWEB backup to the new server.


Restoring the Database

Before You Begin

You must have a database backup file named MPWEB.bak.

or

If you migrated from a previous release, then you may also have one or more database backup files named mpweb.dat or mpweb_XX.dat. In this case, use the mpweb.dat file to restore the database instead of MPWEB.bak.

The database backup file(s) must have been exported with SQL Server Management Studio or the backup database command from a SQL Server release that is earlier or equal to the release of the SQL Server to which you want to import the database. See the "Creating a Backup File by Exporting the MPWEB Database" section for instructions.

Procedure


Step 1 Access the SQL Server.

If the SQL Server that hosts the MPWEB database runs on a separate (remote) Windows server, locate that Windows server and sign in.

If the SQL Server that hosts the MPWEB database runs on the Cisco Unified MeetingPlace Web Server, log in to that server.


Note If SQL Server runs on a separate (remote) Windows server and you cannot sign in to that separate (remote) Windows sever, then sign in to any Windows-based workstation or server on the network that has a valid installation of SQL Server Management Studio, so you can connect remotely to the SQL Server.


Step 2 Connect to SQL Server by using SQL Server Management Studio.

Select Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio.

If the SQL Server runs locally, select the local MPWEBSQL server name and use Windows Authentication.

If the SQL Server runs remotely, select Browse and choose the appropriate server name and authentication.

Step 3 Navigate to the \Databases folder to verify that the MPWEB database exists on the server.

Step 4 If an MPWEB database exists, verify that no Cisco Unified MeetingPlace Web Server is currently using this database.

Step 5 (Optional) If one or several Cisco Unified MeetingPlace Web Servers are using the database, complete the following:

a. Sign in as an administrator on each server.

b. Stop the Cisco Unified MeetingPlace Web Master Service.

c. Wait for all the Cisco Unified MeetingPlace services, the IIS Admin service, and the World Wide Web publishing service to stop.

Step 6 Delete the MPWEB database if it exists.

a. Right-click the MPWEB database and select Delete.

b. Select Close existing connections.

c. Select OK.

Step 7 Restore the MPWEB database to SQL Server.

a. Right-click the \Databases folder and select Restore Database.

b. For "Source for restore", select From device and click Browse.

Select File for "Backup media".

Select MPWEB.bak from the Backup Location list.

If the MPWEB.bak file does not appear in the Backup Location list, select Add and click the MPWEB.bak file in the appropriate \Database folder. Select OK on the Specify Backup dialog.

c. Check Restore next to the desired backup sets in the Backup Sets to Restore list.

d. Select MPWEB for "Destination to restore".

e. From the Select a Page pane, click Options.

Select Overwrite the existing database from Restore Options.

Select OK..

When the backup is restored, the message "The restore of database `MPWEB' completed successfully." displays.

Step 8 Start the Cisco Unified MeetingPlace Web Master Service or reboot the MPWeb Server.


How to Detach and Attach the MPWEB SQL Database

This document forms part of the process for relocating the Cisco Unified MeetingPlace Web Server (MPWEB) database to a dedicated Microsoft SQL Server instance.

For performance and management reasons, you may choose to relocate the MPWEB SQL database to a standalone instance of Microsoft SQL Server. For SQL server requirements for a remote (off box) SQL installation, see the System Requirements for Cisco Unified MeetingPlace.

Complete the following procedures in the order shown to detach and attach the MPWEB SQL database:

Detaching the Database

Examples: Detaching the Database

Attaching the Database

Examples: Attaching the Database

Detaching the Database

You must detach the MPWEB database with the sp_detach_db command from a SQL Server release that is earlier or equal to the release of the SQL Server to which you want to import the database.

Procedure


Step 1 Sign in to the Cisco Unified MeetingPlace web user portal.

Step 2 Select Admin.

Step 3 Stop the Cisco Unified MeetingPlace Web Master Service.

Step 4 Wait for all Cisco Unified MeetingPlace services, including the IIS Admin service and World Wide Web Publishing service, to stop.

Step 5 Access the SQL Server.

If the SQL Server hosting the MPWEB database runs on the Cisco Unified MeetingPlace Web Server, access the command prompt:

a. Select Start > Run.

b. Enter cmd.

or

If the SQL Server hosting the MPWEB database runs on a separate (remote) Windows server, locate that Windows server and sign in.


Note If you cannot sign in to the separate (remote) Windows server, then sign in to any Windows based workstation or server on the network that has a valid installation of SQL Server Client tools, including the osql command, so that you can remotely connect to the SQL Server.


Step 6 Connect to SQL Server by using osql with the SA account and the appropriate password.

If the SQL Server runs locally, you can omit the -S servername option.

If you are not allowed to connect to this SQL Server as SA, connect by using an account that has enough privileges to backup a database.

Step 7 Access the MPWEB database.

a. Enter use mpweb.

b. Enter go.

Step 8 Display a list of the database files.

a. Enter sp_helpfile.

b. Enter go.

Step 9 Access the SQL Server master database.

a. Enter use master.

b. Enter go.

Step 10 Detach the MPWEB database.

a. Enter sp_detach_db 'MPWEB.

b. Enter go.

Step 11 Decide what you should do with the physical files that you identified in Step 8.

These files constitute your detached database. For example, you can archive these files or use them to attach the associated MPWEB database to another SQL Server.

Step 12 Determine the slave database name(s) on your SQL Server.

a. Enter select name from sysdatabases where name like 'MPWEB%.

b. Enter go.

Step 13 (Optional) If you upgraded from Release 7.0 to Release 8.0, then repeat Step 7 through Step 11 to detach each additional database named MPWEB_XX, replacing the database name MPWEB with MPWEB_XX.


Note The databases are logically linked; therefore, if you want to archive the detached MPWEB database, you must do the same for each MPWEB_XX database. If you want to reattach the MPWEB database to another SQL Server, you must also reattach the MPWEB_XX database(s).


Step 14 Enter exit to exit osql.


Related Topics

Examples: Detaching the Database

Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service module

Relocating the Database

Examples: Detaching the Database

In the following examples, the output is displayed for each osql command that is used in the "Detaching the Database" section.

Sample Output for Connecting to SQL Server

C:> osql -U sa -S SERVERNAME
Password: password
1>

Sample Output for Accessing the MPWEB Database

1> use mpweb
2> go

Sample Output for Displaying a List of Database Files

In this example, the database MPWEB relies on two physical files: C:\MSSQL2K\Data\MPWEB.mdf and C:\MSSQL2K\Data\MPWEB.ldf.

1> sp_helpfile
2> go
name         fileid    filename                   filegroup size   maxsize  growth usage    
------------- ---------- --------------------------- --------- ------- --------- -------
---------
MPWEBData             1 C:\MSSQL2K\Data\MPWEB.mdf   PRIMARY  
2432 KB Unlimited 1024 KB data only
MPWEBLog              2 C:\MSSQL2K\Data\MPWEB.ldf   NULL     
1280 KB Unlimited 10%    log only

Sample Output for Accessing the SQL Server Master Database

1> use master
2> go

Sample Output for Detaching the MPWEB Database

1> sp_detach_db 'MPWEB'
2> go

Sample Output for Determining the Slave Database Name

In this example, the name of the slave database is MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.

1> select name from sysdatabases where name like 'MPWEB%'
2> go
---------------------------------------------------
name                
[char              ]
-------------------------------------------- 
MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1

Sample Output for Exiting osql

1> exit
C:>

Related Topics

Detaching the Database

Attaching the Database

Relocating the Database

Attaching the Database

Ensure that you have a valid detached MPWEB database, usually two files named MPWEB.mdf (data file) and MPWEB.ldf (log file) though file names may vary.

Procedure


Step 1 Access the SQL Server.

If the SQL Server to which you want to attach your MPWEB database runs on the Cisco Unified MeetingPlace Web Server, access the command prompt.

a. Select Start > Run.

b. Enter cmd.

or

If the SQL Server runs on a separate (remote) Windows server, locate that Windows server and sign in.


Note If you cannot sign in to that Windows server, then sign in to any Windows-based workstation or server on the network that has a valid installation of SQL Server Client tools, including the osql command, so that you can remotely connect to the SQL Server.


Step 2 Connect to SQL Server by using osql.

Enter osql -U sa -S server-name, where server-name is the Windows SQL Server to which you want to attach the MPWEB database.

If the SQL Server runs locally, you can omit the -S server-name option.

Step 3 Enter your password for the appropriate SA account.


Note If you are not allowed to connect to this SQL Server as SA, connect by using an account that has enough privileges to attach a database.


Step 4 Determine if a database named MPWEB already exists on this server.

a. Enter select name from sysdatabases where name = 'MPWEB'.

b. Enter go.

Step 5 If no MPWEB database exists, proceed to Step 6.

or

If a MPWEB database exists, ensure that it is not being used by an existing Cisco Unified MeetingPlace Web Server.


Note You cannot attach a MPWEB database to this SQL Server if an active MPWEB database exists already. Before you proceed, you must detach the existing MPWEB database by completing the "Detaching the Database" section.


Step 6 To verify the installation folder of the SQL Server to which you want to restore this database, check the physical location of the SQL Server master database.

a. Enter sp_helpfile master.

b. Enter go.


Note Unless you have a reason to restore your MPWEB database to another disk location, such as for performance and tuning or data recovery reasons, we recommend that you restore the database to the default data folder of this SQL Server installation.


Step 7 Copy the MPWEB.mdf and MPWEB.ldf files under the data folder that you identified in Step 6.

Step 8 Attach the MPWEB database.

a. Enter sp_attach_db 'MPWEB','data path\MPWEB.mdf','data path\MPWEB.ldf'.

b. Enter go.

Step 9 (Optional) If you upgraded from Release 7.0 to Release 8.0, and you have a valid set of files for MPWEB_XX slave database(s), then repeat Step 4 through Step 8 for each slave database, replacing MPWEB with MPWEB_XX to attach that database.

Step 10 Enter exit to exit osql.


Related Topics

Examples: Attaching the Database

Detaching the Database

Relocating the Database

Examples: Attaching the Database

In the following examples, the output is displayed for each osql command that is used in the "Attaching the Database" section.

The following examples use the files MPWEB.mdf and MPWEB.ldf:

Sample Output for Connecting to SQL Server

C:> osql -U sa -S SERVERNAME
Password: password
1>

Sample Output for Checking if the MPWEB Database Exists

1> select name from sysdatabases where name = 'MPWEB'
2> go
name
-----------------------------------------------------
(0 row affected)
1>

Sample Output for Checking the Physical Location of the SQL Server Master Database

In this example, SQL Server Version 2000 is installed in C:\MSSQL2K, and the default data folder is C:\MSSQL2K\data.

1> sp_helpfile master
2> go
name filename filegroup size maxsize growth usage
----------------------------------------------------------------------
master
       C:\MSSQL2K\data\master.mdf
       PRIMARY
       15744 KB           Unlimited 10% data only
1>

Sample Output for Attaching the MPWEB Database

1> sp_attach_db 'MPWEB','data path\MPWEB.mdf','data path\MPWEB.ldf'
2> go

Sample Output for Exiting osql

1> exit
C:>

Related Topics

Detaching the Database

Attaching the Database

Relocating the Database

How to Replace a Cisco Unified MeetingPlace Web Server and Retain the SQL Database

During installation, a MPWEB database is tied to a specific Cisco Unified MeetingPlace Web Server through a unique GUIDWebID that is generated by the Cisco Unified MeetingPlace Web Server software installer. This GUIDWebID is stored in the registry and SQL database. Therefore, if you want to transfer the MPWEB SQL database from the old server to a new server, the new server must use the same GUIDWebID as the old server. This requires preparing the following three components from the old server to the new server:

The whole \MPWEB\Meetings folder (including all sub-folders) in zipped or unzipped format.

The GUIDS.reg file with modifications to add the GUIDWebID and the mpweb slave database filename information. The GUIDS.reg file, as well as the GUIDWebID and DBName registry values, come from the old server.

A backup of the MPWEB database and mpweb slave database(s) from the old server.

Complete the following procedures in the order shown to replace an existing Cisco Unified MeetingPlace Web Server with a new server and retain the data of past meetings so that they are accessible from the new server:

Preparing the Current Cisco Unified MeetingPlace Web Server

Installing the Replacement Cisco Unified MeetingPlace Web Server

Building the Replacement Cisco Unified MeetingPlace Web Server

Preparing the Current Cisco Unified MeetingPlace Web Server

Procedure


Step 1 Stop the Cisco Unified MeetingPlace Web Master Service and the Gateway SIM service.

Step 2 Detach this Cisco Unified MeetingPlace Web Server from the Cisco Unified MeetingPlace Application Server.

a. Open the Gateway SIM Agent.

b. From the Gateway SIM tab, write down the hostname or IP address of the Cisco Unified MeetingPlace Application Server for future reference.


Note You must use the same server reference when you install the new Cisco Unified MeetingPlace Web Server. If the Application Server is specified as a hostname, you will enter that same hostname; if it is specified as an IP address, you will use an IP address later.


c. Select Delete Unit to detach this Web Server from the Application Server.

Step 3 Make a copy of the entire \MPWEB\Meetings folder and its contents.

Step 4 Make a copy of the GUIDS.reg file.

You can find this file where the Cisco Unified MeetingPlace Web Server software files are stored.

Step 5 Open regedit and obtain the registry values for GUIDWebID and DBName.


Caution Ensure that the registry values are correct. Compare the values that you obtained in Step 5 against what you enter in Step 6.

Step 6 Open GUIDS.reg in a text editor and add the GUIDWebID and DBName registry paths and key values.

Step 7 Save the file with these changes.

Step 8 Make a backup of the MPWEB database and the mpweb slave database(s).

Step 9 Copy the GUIDS.reg and the MPWEB backup to the new server.


Related Topics

Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service module

Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager module

How to Back Up and Restore MPWEB SQL Database

What to Do Next

Proceed to the "Installing the Replacement Cisco Unified MeetingPlace Web Server" section.

Installing the Replacement Cisco Unified MeetingPlace Web Server

Replacement installations of the Cisco Unified MeetingPlace Web Server software must match the version that was running on the old server.

Before You Begin

Run GUIDS.reg on the new server to add the following four keys in to the registry: GUID IDs for Site, System, Web, and mpweb slave db filename. To run GUIDS.reg, right-click GUIDS.reg, then select merge.

Have the "Preparing the Current Cisco Unified MeetingPlace Web Server" section available to assist you with this procedure.

Procedure


Step 1 Install the Cisco Unified MeetingPlace Web Server software.

Step 2 Reboot the server when you are prompted at the end of the installation.

After the initial reboot, the installation program continues and may reboot a few more times to complete the installation.

Step 3 When prompted for the Cisco Unified MeetingPlace Application Server information, enter the hostname or IP address of the Application Server from which you detached the Web Server.

Step 4 After the installation completes, verify that the Cisco Unified MeetingPlace Web Server software is functional.


Related Topics

Installing the Cisco Unified MeetingPlace Web Server Software module

What to Do Next

Proceed to the "Building the Replacement Cisco Unified MeetingPlace Web Server" section.

Building the Replacement Cisco Unified MeetingPlace Web Server

Before you Begin

Verify that the release of Cisco Unified MeetingPlace Web Server software that is installed on the new server is either the same or later than the release installed on the old server.

Know how to use Enterprise Manager or the osql drop database command.

See the "Restoring the Database" section for more information about the osql command.

Procedure


Step 1 Stop the Cisco Unified MeetingPlace Web Master Service.

Step 2 Use Enterprise Manager or the osql drop database command to delete the MPWEB SQL database.

This database was created automatically during the Cisco Unified MeetingPlace Web Server software installation.

Step 3 Use either Enterprise Manager or the osql restore database command to restore the old MPWEB database on to the new server.

Step 4 Delete all contents in the \MPWeb\Meetings\ folder.

Step 5 Restore all the files from the old server in to \MPWeb\Meetings folder.

Step 6 Reboot the server or restart the Cisco Unified MeetingPlace Web Master Service.

Step 7 Update the Cisco Unified MeetingPlace Web Administration page.

a. Sign in to the Cisco Unified MeetingPlace web user portal with a system administrator profile.

b. Select Admin.

c. Select Web Server.

d. Update appropriate fields, such as the Web Server Hostname.


Related Topics

Changing the Web Server Hostname From an IP Address to a Hostname in the Configuring Security Features for the Cisco Unified MeetingPlace Web Server module

Setting Your Web Server Options in the Quick Start Configuration: Cisco Unified MeetingPlace Web Scheduling Interface for Scheduling and Joining Meetings module

Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service module

Updating the Indices on the SQL Database

The SQL database needs regular maintenance. If the SQL database is running slowly, or if the SQL database is running on a remote SQL server, then you should run this procedure on a nightly or weekly basis.

Procedure


Step 1 Launch SQL Enterprise manager.

Step 2 Select the Cisco Unified MeetingPlace Web Server software database, which is named something similar to MPWEB_<GUID_ID>_<Location>.

<Location> can be either 1 or 2, depending on whether this is an internal or an external Web Server.

Step 3 Select Tools > Wizards from the menu options at the top of the window.

Step 4 Expand on the Management option.

Step 5 Select Database Maintenance Plan Wizard.

Step 6 Select Next on the Welcome to the Database Maintenance Plan Wizard page.

Step 7 Select the database on the Select Database page.

Step 8 Select Next.

Step 9 Check Reorganize data and index pages on the Update Data Optimization Information page.

Step 10 Select Next.

Step 11 (Optional) Change the schedule on which this maintenance procedure runs.

Step 12 Select Next on the Database Integrity Check page.

Step 13 Uncheck Backup the database on the Specify the database backup plan page.

Step 14 Select Next.

Step 15 Select Next on the following pages:

Specify backup disk directory page

Specify the transaction log backup plan page

Reports to generate page

Maintenance Pan History page

Step 16 Select Finish on the Completing the maintenance plan wizard page.


How to Use a Custom TCP Port for the SQL Server Connection

Customizing the SQL Port for the Local SQL Database

Customizing the SQL Port for the Remote SQL Database

Switching from the Local Database to the Remote Database on the Custom Port

Customizing the SQL Port for the Local SQL Database

Procedure


Step 1 In the SQL server network utility, perform the following:


Note To perform this operation in SQL Server 2008, use the SQL Server Configuration Manager tool.


a. Select TCP.

b. Select Properties

c. Change the default port from 1433 to the desired port.

d. Select OK.

Step 2 Stop the SQL server.

Step 3 Start the SQL server.

Step 4 Edit the registry:

a. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Latitude\ODBC.

b. Create a registry key of type DWORD named SlaveDBPort.

c. Set the created entry to your desired value for the port.

Step 5 Restart the Cisco Unified MeetingPlace Web Master Service.


Customizing the SQL Port for the Remote SQL Database

Procedure


Step 1 Install the Cisco Unified MeetingPlace Web Server software as usual, choosing remote database (this will install with the default port, 1433).

Step 2 Use the SQL server network utility to change the port on the remote database:


Note To perform this operation in SQL Server 2008, use the SQL Server Configuration Manager tool.


a. Select TCP.

b. Select Properties.

c. Change the default port from 1433 to the desired port.

d. Select OK.

Step 3 Stop the SQL server.

Step 4 Start the SQL server.

Step 5 Edit the registry:

a. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Latitude\ODBC.

b. Create a registry key of type DWORD named SlaveDBPort.

c. Set the created entry to your desired value for the port.

Step 6 Select Start > Programs > Administrative Tools > Open Data Sources (ODBC).

Step 7 Select System DSN.

Step 8 Select MPWEB.

Step 9 Select Configure.

Step 10 Select Next on the Microsoft SQL Server DSN Configuration screen.

Step 11 Select Client Configuration.

Step 12 Uncheck Dynamically determine port box.

Step 13 Enter your custom port number.

Step 14 Select OK.

Step 15 Close ODBC.

Step 16 Restart the Cisco Unified MeetingPlace Web Master Service.


Switching from the Local Database to the Remote Database on the Custom Port

Procedure


Step 1 Start with the local database on default port 1433.

Step 2 Stop the Cisco Unified MeetingPlace Web Master Service.

Step 3 Use the SQL server network utility to change the port on the remote database:


Note To perform this operation in SQL Server 2008, use the SQL Server Configuration Manager tool.


a. Select TCP.

b. Select Properties

c. Change the default port from 1433 to the desired port.

d. Select OK.

Step 4 Stop the SQL server.

Step 5 Start the SQL server.

Step 6 Edit the registry:

a. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Latitude\ODBC.

b. Create a registry key of type DWORD named SlaveDBPort.

c. Set the created entry to your desired value for the port.

Step 7 Select Start > Programs > Administrative Tools > Open Data Sources (ODBC).

Step 8 Select System DSN.

Step 9 Select MPWEB.

Step 10 Select Configure.

Step 11 Change the "Which SQL server do you want to connect to" field to the remote SQL server name.

Step 12 Select Next on the Microsoft SQL Server DSN Configuration screen.

Step 13 Select Client Configuration.

Step 14 Uncheck Dynamically determine port box.

Step 15 Enter your custom port number.

Step 16 Select OK.

Step 17 Close ODBC.

Step 18 On the web server, open the MeetingPlace Gateway Configuration utility.

Step 19 Select Web Server.

Step 20 Change the database name from (local) to remote database.

Step 21 Enter the user name and password for the remote database.

Step 22 Select Apply.

Step 23 Select OK.

Step 24 Start the Cisco Unified MeetingPlace Web Master Service.


Relocating the Database

You may want to relocate the database and put the Cisco Unified MeetingPlace Web Server software and databases on separate servers, for example, if your Web Server is running out of disk space, or for performance or backup considerations.


Note Do not uninstall the local SQL Server if you are using remote SQL Server 2008.



Step 1 Detach the MPWEB SQL databases on the existing (for example, local) SQL Server.

Step 2 Attach the MPWEB SQL databases to the new (for example, remote) SQL Server.

Step 3 On the Web Server, change the Database Connection settings to point to the new (in this example, remote) SQL Server:

a. Double-click the orange door icon in the System Tray.

b. Click Web Server.

c. Enter the remote SQL server name in the Server field.

d. Enter the new Username and Password.

e. Click OK.


Related Topics

Detaching the Database

Attaching the Database