Cisco Cisco Unified MeetingPlace Video Integration Anleitung Für Quick Setup
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.
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:
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.
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.
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.
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.
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.