Cisco Unified MeetingPlace

Document ID: 50988

PDF Downloads MeetingPlace Web MPWEB SQL Database Attachment

Introduction

This document provides steps for attaching the MPWEB Structured Query Language (SQL) database.

Note: In this document, "SQL Server" refers to any version of Microsoft SQL Server or Microsoft Desktop Engine (MSDE) mentioned in the Components Used section.

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

The information in this document is based on these software versions:

• Cisco MeetingPlace Web versions 4.2.5 and later

• MSDE versions 1.0 and 2000

• Microsoft SQL Server versions 7.0 and 2000

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

For more information on document conventions, refer to the Cisco Technical Tips Conventions.

Attach the Database

Complete these steps:

1. Make sure you have a valid detached MPWEB database. (There are usually two files, MPWEB.mdf and MPWEB.ldf, although the names may vary.) Refer to MeetingPlace Web MPWEB SQL Database Detachment for instructions on how to detach an MPWEB SQL database. This document assumes that you have two files called MPWEB.mdf (data file) and MPWEB.ldf (log file) that have been detached with the sp_detach_db command from a SQL Server whose version is earlier than or equal to that of the SQL Server to which you wish to import the database.

2. If the SQL Server to which you want to attach your MPWEB database runs on the Cisco MeetingPlace Web server, proceed to the next step. If the SQL Server runs on a separate (remote) Windows server, locate that Windows server and log in to it. If you cannot log in to that Windows server, you should log 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 remotely connect to the SQL Server.

3. Go to Start > Run and issue the cmd command to access the command prompt.

4. Connect to the SQL Server by issuing the osql command with the sa account and the appropriate password, as shown here:

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

   Note: If the SQL Server runs locally, you can omit the -S server_name option. The server_name argument stands for the Windows server name.

   Note: If you are not allowed to connect to this SQL Server as sa, connect using an account that has the privileges necessary to attach a database.

5. Check whether a database called MPWEB already exists on this server.

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

6. If no MPWEB database exists, proceed to next step. If an MPWEB database exists, make sure it is not being used by an existing Cisco MeetingPlace Web server. You cannot attach an MPWEB database to this SQL Server if one is already active. You must drop (or detach) the existing MPWEB database before you proceed.

7. Verify the installation folder of the SQL Server you want to restore this database to by checking the physical location of the SQL Server master database:

   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>

8. In this example, SQL Server 2000 has been installed at C:\MSSQL2K, and the default Data folder is C:\MSSQL2K\data. Unless you have a specific reason to restore your MPWEB database to another disk location (for performance and tuning or data recovery reasons), you should restore it into the default Data folder of this SQL Server installation.

9. Copy the MPWEB.mdf and MPWEB.ldf files in the Data folder identified in the previous step.

10. Attach the MPWEB database:

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

11. If Cisco MeetingPlace Web 4.3.0.x is installed, there is a second, slave MPWEB database that needs to be attached. Its name includes a series of digits that varies from one installation to another. Assuming you have a valid set of files for the MPWEB-Slave-xxxxxxxx database, you need to follow Steps 5 through 10 (replacing "MPWEB" with "MPWEB-Slave-xxxxxxxx") to attach that database.

12. Issue the exit command to exit osql.

Related Information

• MeetingPlace Web MPWEB SQL Database Detachment
• Voice Technology Support
• Voice and IP Communications Product Support
• Troubleshooting Cisco IP Telephony
• Technical Support - Cisco Systems