Cisco Cisco MeetingPlace Gateway SIM Anleitung Für Quick Setup

Seite von 766
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Back Up and Restore MPWEB SQL Database
11
 
Step 4
Select a fully qualified path and filename for your database export.
Note
If you are connected to the SQL Server by running osql on a remote workstation or server, this 
path must be valid on the Windows server that hosts SQL Server, not on your local workstation.
Step 5
Export the database.
a.
Enter backup database MPWEB to disk = 'fullyqualifiedpath', where fullyqualifiedpath is the 
location that you chose in 
Step 4
.
b.
Enter go.
Step 6
Review the informational messages to confirm that the operation is successful.
Step 7
Determine the slave database name(s) on your SQL Server.
a.
Enter select name from sysdatabases where name like 'MPWEB%'.
b.
Enter go.
The results should include either one or two slave databases.
Step 8
Back up the slave database(s).
a.
Enter backup database [MPWEB_XX] to disk = 'C:\temp\mpweb_XX.dat', where XX are the 
digits of the first slave database and brackets enclose the database name.
b.
Enter go.
Step 9
Repeat 
Step 8
 for the second slave database, if applicable.
Step 10
Enter exit to exit osql.
Step 11
Save the mpweb.dat and each mpweb_XX.dat file in a safe location, on a tape or network drive on 
another server, for example.
Related Topics
  •
What to Do Next
Proceed to the 
Examples: Exporting the MPWEB Database to Create a Backup File
In the following examples, the output is displayed for each command that is used in the 
.
Sample Output for Connecting to the SQL Server
C:> osql -U sa -S SERVERNAME
Password: password
1>
Sample Output for Exporting to the Database
1> backup database MPWEB to disk = 'C:\temp\mpweb.dat'
2> go