Cisco Cisco MeetingTime Quick Setup Guide
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Back Up and Restore MPWEB SQL Database
13
Note
If you cannot log on to the separate 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 you can connect remotely to the SQL Server.
or server on the network that has a valid installation of SQL Server Client tools including the
osql command, so you can connect remotely to the SQL Server.
Step 2
Connect to SQL Server by using osql with the SA account and the appropriate password.
•
Enter osql -U sa -S servername, where servername is the Windows server name.
•
If the SQL Server runs locally, you can omit the option -S servername.
•
If you are not allowed to connect to this SQL Server as SA, connect by using an account with enough
privileges to back up a database.
privileges to back up a database.
Step 3
Check if a database called MPWEB exists on this server.
a.
Enter select name from sysdatabases where name like 'MPWEB%'.
b.
Enter go.
Step 4
If a MPWEB database exists, verify that no Cisco Unified MeetingPlace Web Server is currently using
this database.
this database.
Step 5
(Optional) If one or multiple Cisco Unified MeetingPlace Web Servers are using the database, complete
the following:
the following:
a.
Log on as an administrator on each server.
b.
Stop the Cisco Unified MeetingPlace Web Conferencing service.
c.
Wait for all the Cisco Unified MeetingPlace Web Conferencing services, the IIS Admin service, and
the World Wide Web publishing service to stop.
the World Wide Web publishing service to stop.
d.
Enter drop database MPWEB to drop the database.
e.
Enter go.
Step 6
Before you import your MPWEB database to SQL Server, find out which database physical files are
associated with this MPWEB database.
associated with this MPWEB database.
a.
Enter restore filelistonly from disk = 'C:\temp\mpweb.dat'.
b.
Enter go.
Step 7
Verify the installation folder of the SQL Server where you want to restore this database and check the
physical location of the SQL Server master database.
physical location of the SQL Server master database.
a.
Enter sp_helpfile master.
b.
Enter go.
Note
Unless you have a specific reason to restore your MPWEB database to another disk location,
such as for performance and tuning or data recovery, we recommend that you restore the
MPWEB database to the default Data folder of this SQL Server installation.
such as for performance and tuning or data recovery, we recommend that you restore the
MPWEB database to the default Data folder of this SQL Server installation.
Step 8
Restore your database and relocate the database physical files to the correct location.
a.
Enter restore database MPWEB from disk = 'C:\temp\mpweb.dat' with move 'MPWEBData'
to 'D:\MSSQLServer\Data\MPWEB.MDF', move 'MPWEBLog' to
'D:\MSSQLServer\Data\MPWEB.LDF'.
to 'D:\MSSQLServer\Data\MPWEB.MDF', move 'MPWEBLog' to
'D:\MSSQLServer\Data\MPWEB.LDF'.
b.
Enter go.