Cisco Cisco MeetingTime Quick Setup Guide
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Back Up and Restore MPWEB SQL Database
15
Sample Output for Verifying Folder Installation and Location of SQL Database
In this example, SQL Server (version 2000) was installed in D:\MSSQLServer, and the default 'Data'
folder is D:\MSSQLServer\data.
folder is D:\MSSQLServer\data.
1> sp_helpfile master
2> go
name filename filegroup size maxsize growth
usage
----------------------------------------------------------------------
master
D:\MSSQLServer\data\master.mdf
PRIMARY
15744 KB Unlimited 10% data only
1>
Sample Output for Restoring the MPWEB Database by Using the Move Clause
In this example, additional running upgrade step messages are displayed because the database backup
file was created by an earlier version of SQL Server.
file was created by an earlier version of SQL Server.
1> 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'
2> go
Processed 216 pages for database 'MPWEB', file 'MPWEBData' on file 1.
Processed 1 pages for database 'MPWEB', file 'MPWEBLog' on file 1.
Converting database 'MPWEB' from version 515 to the current version 539.
Database 'MPWEB' running the upgrade step from version 515 to version 524.
Database 'MPWEB' running the upgrade step from version 524 to version 525.
Database 'MPWEB' running the upgrade step from version 525 to version 526.
Database 'MPWEB' running the upgrade step from version 526 to version 527.
Database 'MPWEB' running the upgrade step from version 527 to version 528.
Database 'MPWEB' running the upgrade step from version 528 to version 529.
Database 'MPWEB' running the upgrade step from version 529 to version 530.
Database 'MPWEB' running the upgrade step from version 530 to version 531.
Database 'MPWEB' running the upgrade step from version 531 to version 532.
Database 'MPWEB' running the upgrade step from version 532 to version 533.
Database 'MPWEB' running the upgrade step from version 533 to version 534.
Database 'MPWEB' running the upgrade step from version 534 to version 535.
Database 'MPWEB' running the upgrade step from version 535 to version 536.
Database 'MPWEB' running the upgrade step from version 536 to version 537.
Database 'MPWEB' running the upgrade step from version 537 to version 538.
Database 'MPWEB' running the upgrade step from version 538 to version 539.
To achieve optimal performance, update all statistics on the 'MPWEB' database by running
sp_updatestats.
RESTORE DATABASE successfully processed 217 pages in 0.428 seconds (4.136 MB/sec).
1>
Sample Output for Restoring the MPWEB Slave Database
1> restore database [MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1] from disk =
'C:\temp\mpweb_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.dat' with move
'MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1Data' to
'D:\MSSQLServer\Data\MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.MDF', move
'MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1Log' to
'D:\MSSQLServer\Data\MPWEB_E22AF0EC-805F-45D4-8F76-FB0C6378A5EC-1.LDF'
2> go
Sample Output for Exiting osql
1> exit
C:>