Cisco Cisco Unified MeetingPlace Web Conferencing Guide D’Installation Rapide
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Manage the SQL Database Size
9
Step 4
Modify properties.
a.
Enter alter database mpweb set auto_shrink on, recovery simple, torn_page_detection on.
b.
Enter go.
Step 5
If you are low on disk space because the database file is already large, force an immediate database
shrink and remove empty space in the database files by entering dbcc shrinkdatabase ('mpweb',
percent). where percent is the amount of free space that you want to allow.
shrink and remove empty space in the database files by entering dbcc shrinkdatabase ('mpweb',
percent). where percent is the amount of free space that you want to allow.
Examples: Modifying the SQL Database Properties to Manage Database Size
In the following examples, the output is displayed for each command that is used in the
Sample Output for Viewing Current Database Properties
In this example, Recovery Mode is set to FULL and Torn Page Detection and Auto Shrink are not
configured on this database.
configured on this database.
1> sp_helpdb MPWEB
2> go
name db_size owner dbid created status
compatibility_level
MPWEB 1254.00 MB sa 5 Oct 16 2003
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL,
Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52,
IsAutoCreateStatistics, IsAutoUpdateStatistics
Sample Output for Modifying Database Properties
1> alter database mpweb set auto_shrink on, recovery simple, torn_page_detection on
2> go
1> sp_helpdb MPWEB
2> go
name db_size owner dbid created status
compatibility_level
MPWEB 1254.00 MB sa 5 Oct 16 2003
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE,
Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoShrink,
IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics
Sample Output for Decreasing File Size
In this example, the size of the files are decreased in the MPWEB database to allow 10 percent free space
in the files of MPWEB.
in the files of MPWEB.
1> dbcc shrinkdatabase ('mpweb', 10)
2> go
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
5 2 2912 1280 2912 1280
(1 row affected)
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.