Cisco Cisco MeetingPlace Gateway SIM Anleitung Für Quick Setup

Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server

How to Back Up and Restore MPWEB SQL Database

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.

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

“Creating a Backup File by Exporting the MPWEB Database” section on page 10

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.

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.

Select Start > Run.

Enter cmd.

•

If the SQL Server hosting the MPWEB database runs on a separate Windows server, locate that
Windows server and log on.