Cisco Cisco Unified MeetingPlace 7.1 Guide D’Installation Rapide

Page de 766
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Detach and Attach the MPWEB SQL Database
21
 
1>
Sample Output for Checking the Physical Location of the SQL Server Master Database
In this example, SQL Server Version 2000 is installed in C:\MSSQL2K, and the default data folder is 
C:\MSSQL2K\data. 
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>
Sample Output for Attaching the MPWEB Database
1> sp_attach_db 'MPWEB','data path\MPWEB.mdf','data path\MPWEB.ldf'
2> go
Sample Output for Exiting osql 
1> exit
C:>
Relocating the Database
You may want to relocate the database and put the Cisco Unified MeetingPlace application and 
databases onto different servers. Examples are if the server you are using is running out of disk space, 
or for performance or backup considerations. 
Note
Do not uninstall the local SQL Server if you are using remote SQL Server 2005. If, however, you are 
using remote SQL Server 2000, then you may choose to uninstall the SQL Server software and delete 
the MPWEB SQL database files from the Cisco Unified MeetingPlace Web Server. 
Procedure
Step 1
Detach the MPWEB SQL databases on the existing (for example, local) SQL Server: 
Follow the instructions in the 
Step 2
Attach the MPWEB SQL databases to the new SQL Server: 
Follow the instructions in the 
Step 3
Change the Database Connection settings on your Cisco Unified MeetingPlace Web Conferencing server 
to point to the new SQL Server: 
a.
Double-click the orange door icon in the System Tray. 
b.
Select Web Conferencing
c.
Enter the new SQL server name in the Server field. 
d.
Enter the new Username and Password.