Cisco Cisco Unified MeetingPlace 8.6 Guide D’Installation Rapide
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.
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.
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.
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.
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.
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.
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'.