MeetingPlace Moderator: /* Preparing the Current Cisco Unified MeetingPlace Web Server */

2010-06-29T19:14:39Z

Preparing the Current Cisco Unified MeetingPlace Web Server

New page

'''Main page:''' [[Cisco Unified MeetingPlace, Release 8.0]]

'''Back to:''' [[Cisco Unified MeetingPlace Release 8.0 -- Configuration|Configuration]]

'''Back to:''' [[Cisco Unified MeetingPlace Release 8.0 -- Maintenance|Maintenance]]

'''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://docwiki.cisco.com/wiki/Cisco_Unified_MeetingPlace%2C_Release_8.0_--_Planning_Your_Deployment.

'''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 2000 Online Help package from Microsoft.
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Accessing Information on the SQL Server Database|Accessing Information on the SQL Server Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Create and Use a Least-Privileged SQL Account for the Web Server|How to Create and Use a Least-Privileged SQL Account for the Web Server]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Restoring the Cisco Unified MeetingPlace Web Server After Boot Failure|Restoring the Cisco Unified MeetingPlace Web Server After Boot Failure]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Change and Apply a New SQL Password to the Cisco Unified MeetingPlace Web Server Software|How to Change and Apply a New SQL Password to the Cisco Unified MeetingPlace Web Server Software]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Manage the SQL Database Size|How to Manage the SQL Database Size]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Back Up and Restore MPWEB SQL Database|How to Back Up and Restore MPWEB SQL Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Detach and Attach the MPWEB SQL Database|How to Detach and Attach the MPWEB SQL Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Replace a Cisco Unified MeetingPlace Web Server and Retain the SQL Database|How to Replace a Cisco Unified MeetingPlace Web Server and Retain the SQL Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Updating the Indices on the SQL Database|Updating the Indices on the SQL Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Use a Custom TCP Port for the SQL Server Connection|How to Use a Custom TCP Port for the SQL Server Connection]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Relocating the Database|Relocating the Database]]

== Accessing Information on the SQL Server Database ==

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

# Sign in to the Cisco Unified MeetingPlace web user portal.
# Select '''Admin'''.
# Select '''Database'''.
# Select a database command.
# 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:
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Creating a Least-Privileged SQL Account for the Web Server|Creating a Least-Privileged SQL Account for the Web Server]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Updating SQL Account Access from the MeetingPlace Gateway Configurations Utility|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 =====

# Open the SQL Server Enterprise Manager and create a new login:
## On the Start menu, select '''Programs > SQL Server 2000 > Enterprise Manager'''.
## Select a server group to expand it, then select the name of a server.
## Select '''Security > New Login'''.
#: The SQL Server Login Properties window displays.
# Enter a name for the login on the General tab.
# Select '''SQL Server Authentication'''.
# Enter a password for the account.
# Select '''MPWEB''' from the Database drop-down menu to set the MPWEB database as the default database.
# Select the '''Database Access''' tab.
# Specify the database roles for the MPWEB database:
## Check the '''MPWEB''' database in the Databases table.
## Check the boxes for the following roles in the Database Roles table:
##* db_datareader
##* db_datawriter
##* db_ddladmin
# 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.
# 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 [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Creating a Least-Privileged SQL Account for the Web Server|Creating a Least-Privileged SQL Account for the Web Server]] for instructions.

===== Procedure =====

# Stop the Cisco Unified MeetingPlace Web Master Service.
# Open the MeetingPlace Gateway Configurations utility.
# Select the '''Web Server''' tab.
# 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.
# Enter the username and password that you applied to the SQL Server.
# Select '''OK'''.
# Start the Cisco Unified MeetingPlace Web Master Service.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service#Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service|Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service]] module
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager#Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager|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 =====

# Stop the Cisco Unified MeetingPlace Web Master Service.
# Verify that all Cisco Unified MeetingPlace services are shut down on the Web Server, including the IIS Admin Service and WWW Publishing Service.
# Open Enterprise Manager and navigate to the \Databases folder.
# Select and expand the '''MPWEB''' database.
# Select '''Tables '''from the left pane.
# Right-click '''System''' in the right pane.
# Select '''Open Table > Return All Rows'''.
# Change the value in the HostName column to the desired value.
# 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 [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager#Changing the Cisco Unified MeetingPlace Application Server Connection Configured in the Gateway SIM|Changing the Cisco Unified MeetingPlace Application Server Connection Configured in the Gateway SIM]] in the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server|Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server]] module.
* [[Cisco Unified MeetingPlace Release 8.0 -- Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service#Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service|Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service]] module

== How to Change and Apply a New SQL Password to the Cisco Unified MeetingPlace Web Server Software ==

Complete the following tasks in the order shown to change the SQL password and apply the new password to the Cisco Unified MeetingPlace Web Server software:
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Changing the SQL Password If You Know the Old Password|Changing the SQL Password If You Know the Old Password]] or
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Changing the SQL Password if You Do Not Know the Old Password|Changing the SQL Password if You Do Not Know the Old Password]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Applying the New SQL Password to the Cisco Unified MeetingPlace Web Server Software|Applying the New SQL Password to the Cisco Unified MeetingPlace Web Server Software]].

=== Changing the SQL Password If You Know the Old Password ===

===== Before You Begin =====

If you do not know the old password, proceed to the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Changing the SQL Password if You Do Not Know the Old Password|Changing the SQL Password if You Do Not Know the Old Password]].

===== Procedure =====

# Stop the Cisco Unified MeetingPlace Web Master Service.
#:'''Caution! ''' Changing the SQL Server account password while the Web Master Service is running will result in an immediate outage. Stop the service before continuing with the password change procedure.
# Open Enterprise Manager.
# Expand the Security folder.
# Select '''Logins'''.
#: A list of accounts displays on the right.
# Double-click the SQL account that you want to change.
# Change the password in the configuration window.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service#Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service|Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service]] module

===== What to Do Next =====

Proceed to the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Applying the New SQL Password to the Cisco Unified MeetingPlace Web Server Software|Applying the New SQL Password to the Cisco Unified MeetingPlace Web Server Software]].

=== Changing the SQL Password if You Do Not Know the Old Password ===

===== Before You Begin =====

If you do know the old password, complete the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Changing the SQL Password If You Know the Old Password|Changing the SQL Password If You Know the Old Password]] instead.

===== Procedure =====

# Stop the Cisco Unified MeetingPlace Web Master Service.
#:'''Caution! ''' Changing the SQL Server account password while the Web Master Service is running will result in an immediate outage. Stop the service before continuing with the password change procedure.
# Open a DOS command window.
# Sign in to SQL Server by entering '''C:\osql -E''''' nt_acct'', where ''nt_acct'' is NT account that has access right to the server.
# Change the password by entering '''sp_password null, '''''new_pwd''''', sa''', where '''null''' represents the password that you do not know and ''new_pwd'' is the new sql password.
# Enter '''go'''.

===== Example: Changing the SQL Password by Using osql =====

This example shows the osql commands executed to sign in to osql by using the NT account mpadmin and to change the SQL account SA password from some unknown value to new_pwd.
: <tt> C:\>osql -E mpadmin </tt>
: <tt> 1> sp_password null, new_pwd, sa </tt>
: <tt> 2> go </tt>
: <tt> Password changed </tt>
: <tt> 1> exit </tt>

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service#Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service|Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service]] module

===== What to Do Next =====

Proceed to the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Applying the New SQL Password to the Cisco Unified MeetingPlace Web Server Software|Applying the New SQL Password to the Cisco Unified MeetingPlace Web Server Software]].

=== Applying the New SQL Password to the Cisco Unified MeetingPlace Web Server Software ===

===== Before You Begin =====
* Ensure that the username and password information that you will provide exists on the SQL Server and that the proper database access rights are assigned.
: See the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Creating a Least-Privileged SQL Account for the Web Server|Creating a Least-Privileged SQL Account for the Web Server]] for more information.
* Verify that the Cisco Unified MeetingPlace Web Master Service is stopped on the Web Server, including IIS Admin and WWW Publishing services.
*:'''Caution! ''' You cannot create or change the username or password on the SQL Server in the Web Server tab. This tab only supplies the Cisco Unified MeetingPlace Web Server software with the proper SQL database login information.
* Complete either the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Changing the SQL Password If You Know the Old Password|Changing the SQL Password If You Know the Old Password]] or the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Changing the SQL Password if You Do Not Know the Old Password|Changing the SQL Password if You Do Not Know the Old Password]]. You will need this information for Step 3 of this procedure.

===== Procedure =====

# Open the Cisco Unified MeetingPlace Gateway Configurations utility.
# Select the '''Web Server''' tab.
# Change the old SQL password to the new SQL password.
# Select '''Apply'''.
# Select '''OK'''.
# Restart the Cisco Unified MeetingPlace Web Master Service.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service#Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service|Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service]] module
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager#Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager|Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager]] module

== How to Manage the SQL Database Size ==
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Modifying the SQL Database Properties to Manage Database Size|Modifying the SQL Database Properties to Manage Database Size]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: 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 =====

# Open a DOS command window.
# Sign in to the SQL Server by entering''' C:\osql -U''' ''userid'' '''-P''' ''password'', replacing ''userid'' and ''password'' with the applicable value.
# See the current properties of the database.
## Enter '''sp_helpdb MPWEB'''.
## Enter '''go'''.
# Modify properties.
## Enter '''alter database mpweb set auto_shrink on, recovery simple, torn_page_detection on'''.
## Enter '''go'''.
# 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 =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: Modifying the SQL Database Properties to Manage Database Size|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 [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Manage the SQL Database Size|How to Manage the SQL Database Size]].

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

<tt> 1> sp_helpdb MPWEB </tt>

<tt> 2> go </tt>

<tt> name db_size owner dbid created status </tt>

<tt> compatibility_level </tt>

<tt> MPWEB 1254.00 MB sa 5 Oct 16 2003 </tt>

<tt> Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, </tt>

<tt> Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, </tt>

<tt> IsAutoCreateStatistics, IsAutoUpdateStatistics </tt>

===== Sample Output for Modifying Database Properties =====

<tt> 1> alter database mpweb set auto_shrink on, recovery simple, torn_page_detection on </tt>

<tt> 2> go </tt>

<tt> 1> sp_helpdb MPWEB </tt>

<tt> 2> go </tt>

<tt> name db_size owner dbid created status </tt>

<tt> compatibility_level </tt>

<tt> MPWEB 1254.00 MB sa 5 Oct 16 2003 </tt>

<tt> Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, </tt>

<tt> Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoShrink, </tt>

<tt> IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics </tt>

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

<tt> 1> dbcc shrinkdatabase ('mpweb', 10) </tt>

<tt> 2> go </tt>

<tt> DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages </tt>

<tt> ------ ------ ----------- ----------- ----------- -------------- </tt>

<tt> 5 2 2912 1280 2912 1280 </tt>

<tt> (1 row affected) </tt>

<tt> DBCC execution completed. If DBCC printed error messages, contact your system </tt>

<tt> administrator. </tt>

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Manage the SQL Database Size|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:
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Creating a Backup File by Exporting the MPWEB Database|Creating a Backup File by Exporting the MPWEB Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: Exporting the MPWEB Database to Create a Backup File|Examples: Exporting the MPWEB Database to Create a Backup File]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Restoring the Database|Restoring the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: Restoring the Database|Examples: Restoring the Database]]

=== Creating a Backup File by Exporting the MPWEB Database ===

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

===== Procedure =====

# 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 cease.
# Access the SQL Server.
#* If the SQL Server that is hosting the MPWEB database runs on the Cisco Unified MeetingPlace Web Server, access the command prompt.
## Select '''Start > Run'''.
## 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 applicable 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 connect remotely to the SQL Server.
# Connect to SQL Server by using osql with the SA account and the appropriate password.
#* Enter '''osql -U sa -S''' ''servername'', where ''servername'' is the Windows server name.
#* If the SQL Server runs locally, you can omit the option -S ''servername''.
#* If you are not allowed to connect to this SQL Server as sa, connect by using an account with enough privileges to back up a database.
# Select a fully qualified path and filename for your database export.
#: '''Note: ''' If you are connected to the SQL Server by running osql on a remote workstation or server, this path must be valid on the Windows server that hosts SQL Server, not on your local workstation.
# Export the database.
## Enter''' backup database MPWEB to disk''' = ''''''fullyqualifiedpath''''''', where '''''fullyqualifiedpath''''' is the location that you chose in Step 4.
## Enter '''go'''.
# Review the informational messages to confirm that the operation is successful.
# If you upgraded from Release 7.0 to Release 8.0:
## Determine the slave database name(s) on your SQL Server.
##* Enter '''select name from sysdatabases where name like 'MPWEB%''''.
##* Enter '''go'''.
##: The results should include either one or two slave databases.
## Back up the slave database(s).
##* Enter '''backup database [MPWEB_'''''XX'''''] to disk = 'C:\temp\mpweb_'''''XX'''''.dat'''', where ''XX'' are the digits of the first slave database and brackets enclose the database name.
##* Enter '''go'''.
## Repeat Step 7.2. for the second slave database, if applicable.
# Enter '''exit''' to exit osql.
# Save the mpweb.dat file in a safe location, for example, on a tape or network drive on another server.
#: If you upgraded from Release 7.0 to Release 8.0, then also save your mpweb_''XX''.dat files in a safe location.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: Exporting the MPWEB Database to Create a Backup File|Examples: Exporting the MPWEB Database to Create a Backup File]]

===== What to Do Next =====

Proceed to the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Restoring the Database|Restoring the Database]].

=== Examples: Exporting the MPWEB Database to Create a Backup File ===

In the following examples, the output is displayed for each command that is used in the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Creating a Backup File by Exporting the MPWEB Database|Creating a Backup File by Exporting the MPWEB Database]].

===== Sample Output for Connecting to the SQL Server =====

<tt> C:> osql -U sa -S SERVERNAME </tt>

<tt> Password: <password> </tt>

<tt> 1> </tt>

===== Sample Output for Exporting to the Database =====

<tt> 1> backup database MPWEB to disk = 'C:\temp\mpweb.dat' </tt>

<tt> 2> go </tt>

===== Sample Output for Viewing Informational Messages =====

<tt> Processed 616 pages for database 'MPWEB', file 'MPWEBData' on file 1. </tt>

<tt> Processed 3 pages for database 'MPWEB', file 'MPWEBLog' on file 1. </tt>

<tt> BACKUP DATABASE successfully processed 619 pages in 1.709 seconds (2.962 MB/sec) </tt>

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

<tt> 1> select name from sysdatabases where name like 'MPWEB%' </tt>

<tt> 2> go </tt>

<tt> --------------------------------------------------- </tt>

<tt> name </tt>

<tt> [char ] </tt>

<tt> -------------------------------------------- </tt>

<tt> MPWEB </tt>

<tt> MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1 </tt>

===== Sample Output for Backing Up the Slave Database =====

<tt> 1> backup database [MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1] to disk = </tt>

<tt> 'C:\temp\mpweb_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.dat' </tt>

<tt> 2> go </tt>

===== Sample Output for Exiting osql =====

<tt> 1> exit </tt>

<tt> C:> </tt>

=== Restoring the Database ===

===== Before You Begin =====
* You must have a database backup file called mpweb.dat.
: If you upgraded from Release 7.0 to Release 8.0, then you may also have one or more database backup files called mpweb_''XX''.dat.
* The database backup file(s) must have been exported with 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 [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Creating a Backup File by Exporting the MPWEB Database|Creating a Backup File by Exporting the MPWEB Database]] for instructions.

===== Procedure =====

# Access the SQL Server.
#* If the SQL Server that hosts the MPWEB database runs on the Cisco Unified MeetingPlace Web Server, access the command prompt.
## Select '''Start > Run'''.
## 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 you can connect remotely to the SQL Server.
# Connect to SQL Server by using osql with the SA account and the appropriate password.
#* Enter '''osql -U sa -S''' ''servername'', where ''servername'' is the Windows server name.
#* If the SQL Server runs locally, you can omit the option -S ''servername''.
#* If you are not allowed to connect to this SQL Server as SA, connect by using an account with enough privileges to back up a database.
# Check if a database called MPWEB exists on this server.
## Enter '''select name from sysdatabases where name like 'MPWEB%''''.
## Enter '''go'''.
# If a MPWEB database exists, verify that no Cisco Unified MeetingPlace Web Server is currently using this database.
# (Optional) If one or multiple Cisco Unified MeetingPlace Web Servers are using the database, complete the following:
## Sign in as an administrator on each server.
## Stop the Cisco Unified MeetingPlace Web Master Service.
## Wait for all the Cisco Unified MeetingPlace services, the IIS Admin service, and the World Wide Web publishing service to stop.
## Enter''' drop database MPWEB '''to drop the database.
## Enter '''go'''.
# Before you import your MPWEB database to SQL Server, find out which database physical files are associated with this MPWEB database.
## Enter '''restore filelistonly from disk = 'C:\temp\mpweb.dat''''.
## Enter '''go'''.
# Verify the installation folder of the SQL Server where you want to restore this database and check the physical location of the SQL Server master database.
## Enter '''sp_helpfile master'''.
## Enter '''go'''.
#: '''Note: ''' Unless you have a specific reason to restore your MPWEB database to another disk location, such as for performance and tuning or data recovery, we recommend that you restore the MPWEB database to the default Data folder of this SQL Server installation.
# Restore your database and relocate the database physical files to the correct location.
## Enter '''restore database MPWEB from disk = 'C:\temp\mpweb.dat' with move 'MPWEBData' to 'D:\MSSQLServer\Data\MPWEB.MDF', move 'MPWEBLog' to 'D:\MSSQLServer\Data\MPWEB.LDF''''.
## Enter '''go'''.
#: '''Note: ''' You must use the '''with move''' clause to successfully restore the database because the database backup file contains physical file locations that are not valid for this SQL Server installation.
# Ensure that the operation was successful by reviewing the informational messages.
# If you upgraded from Release 7.0 to Release 8.0, then repeat Step 8 and Step 9 for each slave database to restore the MPWEB_XX slave database files.
# Enter '''exit''' to exit osql.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: Restoring the Database|Examples: Restoring the Database]]

=== Examples: Restoring the Database ===

In the following examples, the output is displayed for each command that is used in the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Restoring the Database|Restoring the Database]].

===== Sample Output for Connecting to SQL Server =====

<tt> C:> osql -U sa -S SERVERNAME </tt>

<tt> Password: password </tt>

<tt> 1> </tt>

===== Sample Output for Checking if the MPWEB Database Exists =====

<tt> 1> select name from sysdatabases where name = 'MPWEB' </tt>

<tt> 2> go </tt>

<tt> name </tt>

<tt> ----------------------------------------------------- </tt>

<tt> MPWEB </tt>

<tt> 1> </tt>

===== Sample Output for Dropping the Database =====

<tt> 1> drop database MPWEB </tt>

<tt> 2> go </tt>

<tt> Deleting database file 'D:\MSSQLServer\Data\MPWEB.LDF'. </tt>

<tt> Deleting database file 'D:\MSSQLServer\Data\MPWEB.MDF'. </tt>

<tt> 1> </tt>

===== Sample Output for Checking Associated Files =====

In this example, the MPWEB database was exported from a MSDE 2000 server. The default `Data' folder for this server is D:\MSSQLServer\Data, and the MPWEB database was created with one data file (logical name = `MPWEBData', physical name = D:\MSSQLServer\Data\MPWEB.mdf) and one log file (logical name = `MPWEBLog', physical name = D:\MSSQLServer\Data\MPWEB.ldf).
: <tt> 1> restore filelistonly from disk = 'C:\temp\mpweb.dat' </tt>
: <tt> 2> go </tt>
: <tt> --------------------------------------------------- </tt>
: <tt> LogicalName PhysicalName Type FileGroupName Size MaxSize </tt>
: <tt> ----------- ------------------------ ------ ------------- -------------- </tt>
: <tt> --------------------- </tt>
: <tt> MPWEBData D:\MSSQLServer\Data\MPWEB.mdf D PRIMARY </tt>
:: <tt> 2490368.000000 35184372080640.000000 </tt>
: <tt> MPWEBLog D:\MSSQLServer\Data\MPWEB.ldf L NULL </tt>
:: <tt> 1310720.000000 35184372080640.000000 </tt>

===== Sample Output for Verifying Folder Installation and Location of SQL Database =====

In this example, SQL Server (version 2000) was installed in D:\MSSQLServer, and the default 'Data' folder is D:\MSSQLServer\data.

<tt> 1> sp_helpfile master </tt>

<tt> 2> go </tt>

<tt> name filename filegroup size maxsize growth </tt>

<tt> usage </tt>

<tt> ---------------------------------------------------------------------- </tt>

<tt> master </tt>

<tt> D:\MSSQLServer\data\master.mdf </tt>

<tt> PRIMARY </tt>

<tt> 15744 KB Unlimited 10% data only </tt>

<tt> 1> </tt>

===== Sample Output for Restoring the MPWEB Database by Using the Move Clause =====

In this example, additional running upgrade step messages are displayed because the database backup file was created by an earlier version of SQL Server.

<tt> 1> restore database MPWEB from disk = 'C:\temp\mpweb.dat' with move 'MPWEBData' to </tt>

<tt> 'D:\MSSQLServer\Data\MPWEB.MDF', move 'MPWEBLog' to 'D:\MSSQLServer\Data\MPWEB.LDF' </tt>

<tt> 2> go </tt>

<tt> Processed 216 pages for database 'MPWEB', file 'MPWEBData' on file 1. </tt>

<tt> Processed 1 pages for database 'MPWEB', file 'MPWEBLog' on file 1. </tt>

<tt> Converting database 'MPWEB' from version 515 to the current version 539. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 515 to version 524. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 524 to version 525. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 525 to version 526. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 526 to version 527. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 527 to version 528. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 528 to version 529. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 529 to version 530. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 530 to version 531. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 531 to version 532. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 532 to version 533. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 533 to version 534. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 534 to version 535. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 535 to version 536. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 536 to version 537. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 537 to version 538. </tt>

<tt> Database 'MPWEB' running the upgrade step from version 538 to version 539. </tt>

<tt> To achieve optimal performance, update all statistics on the 'MPWEB' database by running </tt>

<tt> sp_updatestats. </tt>

<tt> RESTORE DATABASE successfully processed 217 pages in 0.428 seconds (4.136 MB/sec). </tt>

<tt> 1> </tt>

===== Sample Output for Restoring the MPWEB Slave Database =====

<tt> 1> restore database [MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1] from disk = </tt>

<tt> 'C:\temp\mpweb_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.dat' with move </tt>

<tt> 'MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1Data' to </tt>

<tt> 'D:\MSSQLServer\Data\MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.MDF', move </tt>

<tt> 'MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1Log' to </tt>

<tt> 'D:\MSSQLServer\Data\MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.LDF' </tt>

<tt> 2> go </tt>

===== Sample Output for Exiting osql =====

<tt> 1> exit </tt>

<tt> C:> </tt>

== 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:
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Detaching the Database|Detaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: Detaching the Database|Examples: Detaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Attaching the Database|Attaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: 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 =====

# Sign in to the Cisco Unified MeetingPlace web user portal.
# Select '''Admin'''.
# Stop the Cisco Unified MeetingPlace Web Master Service.
# Wait for all Cisco Unified MeetingPlace services, including the IIS Admin service and World Wide Web Publishing service, to stop.
# Access the SQL Server.
#* If the SQL Server hosting the MPWEB database runs on the Cisco Unified MeetingPlace Web Server, access the command prompt:
## Select '''Start > Run'''.
## 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.
# 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.
# Access the MPWEB database.
## Enter '''use mpweb'''.
## Enter '''go'''.
# Display a list of the database files.
## Enter '''sp_helpfile'''.
## Enter '''go'''.
# Access the SQL Server master database.
## Enter '''use master'''.
## Enter '''go'''.
# Detach the MPWEB database.
## Enter '''sp_detach_db 'MPWEB'''.
## Enter '''go'''.
# 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.
# Determine the slave database name(s) on your SQL Server.
## Enter '''select name from sysdatabases where name like 'MPWEB%'''.
## Enter '''go'''.
# (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).
# Enter '''exit''' to exit osql.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: Detaching the Database|Examples: Detaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service#Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service|Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service]] module
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Relocating the Database|Relocating the Database]]

=== Examples: Detaching the Database ===

In the following examples, the output is displayed for each osql command that is used in the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Detaching the Database|Detaching the Database]].

===== Sample Output for Connecting to SQL Server =====

<tt> C:> osql -U sa -S SERVERNAME </tt>

<tt> Password: password </tt>

<tt> 1> </tt>

===== Sample Output for Accessing the MPWEB Database =====

<tt> 1> use mpweb </tt>

<tt> 2> go </tt>

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

<tt> 1> sp_helpfile </tt>

<tt> 2> go </tt>

<tt> name fileid filename filegroup size maxsize growth usage </tt>

<tt> ------------- ---------- --------------------------- --------- ------- --------- ------- </tt>

<tt> --------- </tt>

<tt> MPWEBData 1 C:\MSSQL2K\Data\MPWEB.mdf PRIMARY </tt>

<tt> 2432 KB Unlimited 1024 KB data only </tt>

<tt> MPWEBLog 2 C:\MSSQL2K\Data\MPWEB.ldf NULL </tt>

<tt> 1280 KB Unlimited 10% log only </tt>

===== Sample Output for Accessing the SQL Server Master Database =====

<tt> 1> use master </tt>

<tt> 2> go </tt>

===== Sample Output for Detaching the MPWEB Database =====

<tt> 1> sp_detach_db 'MPWEB' </tt>

<tt> 2> go </tt>

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

<tt> 1> select name from sysdatabases where name like 'MPWEB%' </tt>

<tt> 2> go </tt>

<tt> --------------------------------------------------- </tt>

<tt> name </tt>

<tt> [char ] </tt>

<tt> -------------------------------------------- </tt>

<tt> MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1 </tt>

===== Sample Output for Exiting osql =====

<tt> 1> exit </tt>

<tt> C:> </tt>

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Detaching the Database|Detaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Attaching the Database|Attaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Relocating 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 =====

# 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.
## Select '''Start > Run'''.
## 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.
# 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.
# 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.
# Determine if a database named MPWEB already exists on this server.
## Enter '''select name from sysdatabases where name = 'MPWEB''''.
## Enter '''go'''.
# 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 [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Detaching the Database|Detaching the Database]].
# 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.
## Enter '''sp_helpfile master'''.
## 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.
# Copy the MPWEB.mdf and MPWEB.ldf files under the data folder that you identified in Step 6.
# Attach the MPWEB database.
## Enter '''sp_attach_db 'MPWEB',''''''data path'''''\MPWEB.mdf',''''''data path'''''\MPWEB.ldf''''.
## Enter '''go'''.
# (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.
# Enter '''exit''' to exit osql.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Examples: Attaching the Database|Examples: Attaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Detaching the Database|Detaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Relocating 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 [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Attaching the Database|Attaching the Database]].

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

===== Sample Output for Connecting to SQL Server =====

<tt> C:> osql -U sa -S SERVERNAME </tt>

<tt> Password: password </tt>

<tt> 1> </tt>

===== Sample Output for Checking if the MPWEB Database Exists =====

<tt> 1> select name from sysdatabases where name = 'MPWEB' </tt>

<tt> 2> go </tt>

<tt> name </tt>

<tt> ----------------------------------------------------- </tt>

<tt> (0 row affected) </tt>

<tt> 1> </tt>

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

<tt> 1> sp_helpfile master </tt>

<tt> 2> go </tt>

<tt> name filename filegroup size maxsize growth usage </tt>

<tt> ---------------------------------------------------------------------- </tt>

<tt> master </tt>

<tt> C:\MSSQL2K\data\master.mdf </tt>

<tt> PRIMARY </tt>

<tt> 15744 KB Unlimited 10% data only </tt>

<tt> 1> </tt>

===== Sample Output for Attaching the MPWEB Database =====

<tt> 1> sp_attach_db 'MPWEB','data path\MPWEB.mdf','data path\MPWEB.ldf' </tt>

<tt> 2> go </tt>

===== Sample Output for Exiting osql =====

<tt> 1> exit </tt>

<tt> C:> </tt>

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Detaching the Database|Detaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Attaching the Database|Attaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Relocating 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:
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Preparing the Current Cisco Unified MeetingPlace Web Server|Preparing the Current Cisco Unified MeetingPlace Web Server]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Installing the Replacement Cisco Unified MeetingPlace Web Server|Installing the Replacement Cisco Unified MeetingPlace Web Server]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Building the Replacement Cisco Unified MeetingPlace Web Server|Building the Replacement Cisco Unified MeetingPlace Web Server]]

=== Preparing the Current Cisco Unified MeetingPlace Web Server ===

===== Procedure =====

# Stop the Cisco Unified MeetingPlace Web Master Service and the Gateway SIM service.
# Detach this Cisco Unified MeetingPlace Web Server from the Cisco Unified MeetingPlace Application Server.
## Open the Gateway SIM Agent.
## 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.
## Select '''Delete Unit''' to detach this Web Server from the Application Server.
# Make a copy of the entire \MPWEB\Meetings folder and its contents.
# Make a copy of the GUIDS.reg file.
#: You can find this file where the Cisco Unified MeetingPlace Web Server software files are stored.
# 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.
# Open GUIDS.reg in a text editor and add the GUIDWebID and DBName registry paths and key values.
# Save the file with these changes.
# Make a backup of the MPWEB database and the mpweb slave database(s).
# Copy the GUIDS.reg and the MPWEB backup to the new server.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service#Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service|Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service]] module
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager#Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager|Configuring the Cisco Unified MeetingPlace Gateway System Integrity Manager]] module
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#How to Back Up and Restore MPWEB SQL Database|How to Back Up and Restore MPWEB SQL Database]]

===== What to Do Next =====

Proceed to the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Installing the Replacement Cisco Unified MeetingPlace Web Server|Installing the Replacement Cisco Unified MeetingPlace Web Server]].

=== 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 [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Preparing the Current Cisco Unified MeetingPlace Web Server|Preparing the Current Cisco Unified MeetingPlace Web Server]] available to assist you with this procedure.

===== Procedure =====

# Install the Cisco Unified MeetingPlace Web Server software.
# 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.
# 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.
# After the installation completes, verify that the Cisco Unified MeetingPlace Web Server software is functional.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Installing the Cisco Unified MeetingPlace Web Server Software#Installing the Cisco Unified MeetingPlace Web Server Software|Installing the Cisco Unified MeetingPlace Web Server Software]] module

===== What to Do Next =====

Proceed to the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Building the Replacement Cisco Unified MeetingPlace Web Server|Building the Replacement Cisco Unified MeetingPlace Web Server]].

=== 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 [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Restoring the Database|Restoring the Database]] for more information about the osql command.

===== Procedure =====

# Stop the Cisco Unified MeetingPlace Web Master Service.
# 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.
# Use either Enterprise Manager or the osql restore database command to restore the old MPWEB database on to the new server.
# Delete all contents in the \MPWeb\Meetings\ folder.
# Restore all the files from the old server in to \MPWeb\Meetings folder.
# Reboot the server or restart the Cisco Unified MeetingPlace Web Master Service.
# Update the Cisco Unified MeetingPlace Web Administration page.
## Sign in to the Cisco Unified MeetingPlace web user portal with a system administrator profile.
## Select '''Admin'''.
## Select '''Web Server'''.
## Update appropriate fields, such as the Web Server Hostname.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring Security Features for the Cisco Unified MeetingPlace Web Server#Changing the Web Server Hostname From an IP Address to a Hostname|Changing the Web Server Hostname From an IP Address to a Hostname]] in the [[Cisco Unified MeetingPlace Release 8.0 -- Configuring Security Features for the Cisco Unified MeetingPlace Web Server#Configuring Security Features for the Cisco Unified MeetingPlace Web Server|Configuring Security Features for the Cisco Unified MeetingPlace Web Server]] module
* [[Cisco Unified MeetingPlace Release 8.0 -- Quick Start Configuration for Cisco Unified MeetingPlace Web User Portal for Scheduling and Joining Meetings#Setting Your Web Server Options|Setting Your Web Server Options]] in the [[Cisco Unified MeetingPlace Release 8.0 -- Quick Start Configuration for Cisco Unified MeetingPlace Web User Portal for Scheduling and Joining Meetings#Quick Start Configuration for Cisco Unified MeetingPlace Web User Portal for Scheduling and Joining Meetings|Quick Start Configuration for Cisco Unified MeetingPlace Web User Portal for Scheduling and Joining Meetings]] module
* [[Cisco Unified MeetingPlace Release 8.0 -- Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service#Stopping, Starting, or Restarting the Cisco Unified MeetingPlace Web Master Service|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 =====

# Launch SQL Enterprise manager.
# 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.
# Select '''Tools > Wizards''' from the menu options at the top of the window.
# Expand on the Management option.
# Select '''Database Maintenance Plan Wizard'''.
# Select '''Next''' on the Welcome to the Database Maintenance Plan Wizard page.
# Select the database on the Select Database page.
# Select '''Next'''.
# Check '''Reorganize data and index pages''' on the Update Data Optimization Information page.
# Select '''Next'''.
# (Optional) Change the schedule on which this maintenance procedure runs.
# Select '''Next''' on the Database Integrity Check page.
# Uncheck '''Backup the database''' on the Specify the database backup plan page.
# Select '''Next'''.
# 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
# Select '''Finish '''on the Completing the maintenance plan wizard page.

== How to Use a Custom TCP Port for the SQL Server Connection ==
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Customizing the SQL Port for the Local SQL Database|Customizing the SQL Port for the Local SQL Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Customizing the SQL Port for the Remote SQL Database|Customizing the SQL Port for the Remote SQL Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Switching from the Local Database to the Remote Database on the Custom Port|Switching from the Local Database to the Remote Database on the Custom Port]]

=== Customizing the SQL Port for the Local SQL Database ===

===== Procedure =====

# In the SQL server network utility, perform the following:
#: '''Note: ''' To perform this operation in SQL Server 2005, use the SQL Server Configuration Manager tool.
## Select '''TCP'''.
## Select '''Properties'''
## Change the default port from 1433 to the desired port.
## Select '''OK'''.
# Stop the SQL server.
# Start the SQL server.
# Edit the registry:
## Go to HKEY_LOCAL_MACHINE\SOFTWARE\Latitude\ODBC.
## Create a registry key of type DWORD named '''SlaveDBPort'''.
## Set the created entry to your desired value for the port.
# Restart the Cisco Unified MeetingPlace Web Master Service.

=== Customizing the SQL Port for the Remote SQL Database ===

===== Procedure =====

# Install the Cisco Unified MeetingPlace Web Server software as usual, choosing remote database (this will install with the default port, 1433).
# Use the SQL server network utility to change the port on the remote database:
#: '''Note: ''' To perform this operation in SQL Server 2005, use the SQL Server Configuration Manager tool.
## Select '''TCP'''.
## Select '''Properties'''.
## Change the default port from 1433 to the desired port.
## Select '''OK'''.
# Stop the SQL server.
# Start the SQL server.
# Edit the registry:
## Go to HKEY_LOCAL_MACHINE\SOFTWARE\Latitude\ODBC.
## Create a registry key of type DWORD named '''SlaveDBPort'''.
## Set the created entry to your desired value for the port.
# Select '''Start > Programs > Administrative Tools > Open Data Sources (ODBC)'''.
# Select '''System DSN'''.
# Select '''MPWEB'''.
# Select '''Configure'''.
# Select '''Next''' on the Microsoft SQL Server DSN Configuration screen.
# Select '''Client Configuration'''.
# Uncheck '''Dynamically determine port box'''.
# Enter your custom port number.
# Select '''OK'''.
# Close '''ODBC'''.
# Restart the Cisco Unified MeetingPlace Web Master Service.

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

===== Procedure =====

# Start with the local database on default port 1433.
# Stop the Cisco Unified MeetingPlace Web Master Service.
# Use the SQL server network utility to change the port on the remote database:
#: '''Note: ''' To perform this operation in SQL Server 2005, use the SQL Server Configuration Manager tool.
## Select '''TCP'''.
## Select '''Properties'''
## Change the default port from 1433 to the desired port.
## Select '''OK'''.
# Stop the SQL server.
# Start the SQL server.
# Edit the registry:
## Go to HKEY_LOCAL_MACHINE\SOFTWARE\Latitude\ODBC.
## Create a registry key of type DWORD named '''SlaveDBPort'''.
## Set the created entry to your desired value for the port.
# Select '''Start > Programs > Administrative Tools > Open Data Sources (ODBC)'''.
# Select '''System DSN'''.
# Select '''MPWEB'''.
# Select '''Configure'''.
# Change the "Which SQL server do you want to connect to" field to the remote SQL server name.
# Select '''Next''' on the Microsoft SQL Server DSN Configuration screen.
# Select '''Client Configuration'''.
# Uncheck '''Dynamically determine port box'''.
# Enter your custom port number.
# Select '''OK'''.
# Close '''ODBC'''.
# On the web server, open the MeetingPlace Gateway Configuration utility.
# Select '''Web Server'''.
# Change the database name from (local) to remote database.
# Enter the user name and password for the remote database.
# Select '''Apply'''.
# Select '''OK'''.
# 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 2005. If, however, you are using remote SQL Server 2000, then you may choose to uninstall the SQL Server software and delete the MPWEB SQL database files from the Cisco Unified MeetingPlace Web Server.

# Detach the MPWEB SQL databases on the existing (for example, local) SQL Server.
# Attach the MPWEB SQL databases to the new (for example, remote) SQL Server.
# On the Web Server, change the Database Connection settings to point to the new (in this example, remote) SQL Server:
## Double-click the orange door icon in the System Tray.
## Click '''Web Server'''.
## Enter the remote SQL server name in the Server field.
## Enter the new Username and Password.
## Click '''OK'''.

===== Related Topics =====
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Detaching the Database|Detaching the Database]]
* [[Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server#Attaching the Database|Attaching the Database]]

[[Category: Configuration Information for Cisco Unified MeetingPlace Release 8.0]]

Cisco Unified MeetingPlace Release 8.0 -- Configuring the SQL Server for the Cisco Unified MeetingPlace Web Server - Revision history

MeetingPlace Moderator: 1 revision

MeetingPlace Moderator: /* Preparing the Current Cisco Unified MeetingPlace Web Server */