Cisco Cisco MeetingPlace Gateway SIM Anleitung Für Quick Setup

Seite von 766
 
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Detach and Attach the MPWEB SQL Database
20
 
b.
Enter go.
Step 5
If no MPWEB database exists, proceed to 
Step 6
.
or
If a MPWEB database exists, ensure that it is not being used by an existing Cisco Unified MeetingPlace 
Web Server. 
Note
You cannot attach a MPWEB database to this SQL Server if an active MPWEB database exists 
already. Before you proceed, you must detach the existing MPWEB database by completing the 
Step 6
To verify the installation folder of the SQL Server to which you want to restore this database, check the 
physical location of the SQL Server master database.
a.
Enter sp_helpfile master.
b.
Enter go
Note
Unless you have a reason to restore your MPWEB database to another disk location, such as for 
performance and tuning or data recovery reasons, we recommend that you restore the database 
to the default data folder of this SQL Server installation.
Step 7
Copy the MPWEB.mdf and MPWEB.ldf files under the data folder that you identified in 
Step 6
.
Step 8
Attach the MPWEB database. 
a.
Enter sp_attach_db 'MPWEB','data path\MPWEB.mdf','data path\MPWEB.ldf'.
b.
Enter go.
Step 9
(Optional) If you have a valid set of files for the MPWEB_XX slave database(s), repeat 
Step 4
 through 
Step 9
 for each slave database, replacing MPWEB with MPWEB_XX to attach that database.
Step 10
Enter exit to exit osql.
Examples: Attaching the Database
In the following examples, the output is displayed for each osql command that is used in th
The following examples use the files MPWEB.mdf and MPWEB.ldf:
Sample Output for Connecting to SQL Server 
C:> osql -U sa -S SERVERNAME
Password: password
1>
Sample Output for Checking if the MPWEB Database Exists
1> select name from sysdatabases where name = 'MPWEB'
2> go
name
-----------------------------------------------------
(0 row affected)