Cisco Cisco MeetingTime Quick Setup Guide

Page of 766
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Detach and Attach the MPWEB SQL Database
19
 
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:>
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 Windows server, locate that Windows server and log on.
Note
If you cannot log on to that Windows server, log on 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'.