Cisco Cisco Unified MeetingPlace for Cisco Unified IP Phone Guida All'Installazione Rapida

Pagina di 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.