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
17
 
Step 3
Stop the Cisco Unified MeetingPlace Web Conferencing service.
Step 4
Wait for the Cisco Unified MeetingPlace Web Conferencing services, 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 Windows server, locate that 
Windows server and log on. 
Note
If you cannot log on to the separate 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 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) For each additional database named MPWEB_XX, repeat 
Step 7
 through 
Step 11
 to detach 
that database, replacing the database name MPWEB with MPWEB_XX.