Cisco Cisco Unified MeetingPlace for IBM Lotus Notes クイック設定ガイド
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Back Up and Restore MPWEB SQL Database
12
Sample Output for Viewing Informational Messages
Processed 616 pages for database 'MPWEB', file 'MPWEBData' on file 1.
Processed 3 pages for database 'MPWEB', file 'MPWEBLog' on file 1.
BACKUP DATABASE successfully processed 619 pages in 1.709 seconds (2.962 MB/sec)
Sample Output for Determining the Slave Database Name
In this example, the name of the slave database is
MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.
MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.
1> select name from sysdatabases where name like 'MPWEB%'
2> go
---------------------------------------------------
name
[char ]
--------------------------------------------
MPWEB
MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1
Sample Output for Backing Up the Slave Database
1> backup database [MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1] to disk =
'C:\temp\mpweb_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.dat'
2> go
Sample Output for Exiting osql
1> exit
C:>
Restoring the Database
Before You Begin
•
You must have a file called mpweb.dat or mpweb_XX.dat.
•
This file must have been exported with the backup database command from a SQL Server release
that is earlier or equal to the release of the SQL Server to which you want to import the database.
See the
that is earlier or equal to the release of the SQL Server to which you want to import the database.
See the
for
instructions.
•
If you are restoring the database as part of a failed upgrade and had SSL configured on the original
Web Server system, note that you will have to install the SSL certificates again after the restore.
Web Server system, note that you will have to install the SSL certificates again after the restore.
Procedure
Step 1
Access the SQL Server.
•
If the SQL Server that hosts 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.