Cisco Cisco Unified MeetingPlace Web Conferencing クイック設定ガイド
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Back Up and Restore MPWEB SQL Database
10
How to Back Up and Restore MPWEB SQL Database
Complete the following procedures in the order shown to back up and restore the MPWEB database:
•
•
•
•
•
Creating a Backup File by Exporting the MPWEB Database
This backup file can be restored only on a SQL Server 2000 with equivalent or later service pack
installed.
installed.
Procedure
Step 1
Export the MPWEB database.
•
To export the MPWEB database to create a backup copy while Cisco Unified MeetingPlace
Web Conferencing is running (as part of a daily backup procedure, for example), proceed to
Web Conferencing is running (as part of a daily backup procedure, for example), proceed to
Step 2
.
or
•
To export the MPWEB database so that it can be imported on another SQL Server that can continue
operations for this Cisco Unified MeetingPlace Web Server, stop the Cisco Unified MeetingPlace
Web Conferencing service and wait for all of the web conferencing services, IIS Admin service, and
World Wide Web publishing service to cease.
operations for this Cisco Unified MeetingPlace Web Server, stop the Cisco Unified MeetingPlace
Web Conferencing service and wait for all of the web conferencing services, IIS Admin service, and
World Wide Web publishing service to cease.
Step 2
Access the SQL Server.
•
If the SQL Server that is hosting the MPWEB database runs on the Cisco Unified MeetingPlace Web
Server, access the command prompt.
Server, access the command prompt.
a.
Select Start > Run.
b.
Enter cmd.
or
•
If the SQL Server hosting the MPWEB database runs on a separate Windows server, locate that
Windows server and log on.
Windows server and log on.
Note
If you cannot log on to the applicable 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 that you can connect remotely to the SQL Server.
workstation or server on the network that has a valid installation of SQL Server Client tools,
including the osql command, so that you can connect remotely to the SQL Server.
Step 3
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.