Cisco Cisco MeetingPlace Gateway SIM Anleitung Für Quick Setup

Seite von 766
 
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 
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.
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.
To help prevent the file from growing too large, configure the following three properties for the MPWEB 
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_”).
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.
Step 3
See the current properties of the database.
a.
Enter sp_helpdb MPWEB.
b.
Enter go.