Cisco Cisco Unified MeetingPlace 7.0 クイック設定ガイド
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Manage the SQL Database Size
8
Step 5
Select OK.
Step 6
Restart the Cisco Unified MeetingPlace Web Conferencing service.
Note
When you restart the Web Server, all manual changes made to the registry are lost.
Related Topics
•
in the
module
How to Manage the SQL Database Size
•
•
Modifying the SQL Database Properties to Manage Database Size
The MPWEB database that Cisco Unified MeetingPlace Web Conferencing creates is comprised of two
files: MPWEB.mdf and MPWEB.ldf. The MDF file contains the actual data, while the LDF contains
changes (both the content and timing) made to that data.
files: MPWEB.mdf and MPWEB.ldf. The MDF file contains the actual data, while the LDF contains
changes (both the content and timing) made to that data.
On a SQL server that has been actively and properly managed through regular database backup, this LDF
file (also called Transaction Log) remains a reasonable size. However, if the SQL database has not been
backed up in a while, this transaction log may become very large.
file (also called Transaction Log) remains a reasonable size. However, if the SQL database has not been
backed up in a while, this transaction log may become very large.
To help prevent the file from growing too large, configure the following three properties for the MPWEB
database:
database:
•
Recovery = Simple
•
Torn Page Detection = On
•
Auto Shrink = On
Caution
This procedure applies only to the MPWEB database. Do not apply this procedure to any MPWEB slave
database (these databases have names that begin with “MPWEB_”).
database (these databases have names that begin with “MPWEB_”).
Procedure
Step 1
Open a DOS command window.
Step 2
Log in to SQL Server by entering C:\osql -U userid -P password, replacing userid and password with
the applicable value.
the applicable value.
Step 3
See the current properties of the database.
a.
Enter sp_helpdb MPWEB.
b.
Enter go.