Cisco Cisco MeetingTime Quick Setup Guide

Page of 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