Cisco Unified MeetingPlace

Document ID: 62187

Contents

Introduction
Prerequisites
      Requirements
      Components Used
      Conventions
Modify SQL Database Properties
      Procedure
NetPro Discussion Forums - Featured Conversations
Related Information

Introduction

The MPWEB database that MeetingPlace Web Gateway creates consists of two files, MPWEB.mdf and MPWEB.ldf. The .mdf file contains the actual data, while the .ldf file contains any changes (in both the content and timing) made to the data.

On a Microsoft SQL Server that has been actively and properly managed through regular database backup, this .ldf file (also referred to as a transaction log) remains a reasonable size. However, if the SQL database has not been backed up in a long time, this transaction log may grow very large.

Prerequisites

Requirements

Readers of this document should have knowledge of these topics:

• SQL osql utility

Components Used

The information in this document is based on these software versions:

• Microsoft SQL Server 2000

• Microsoft SQL Server 2000 Desktop Engine

• Cisco MeetingPlace Web (all versions)

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

For more information on document conventions, refer to the Cisco Technical Tips Conventions.

Modify SQL Database Properties

This document describes the procedure to configure the database properties to help prevent excessive growth of the file. There are three important properties that the database should have:

• Recovery = Simple

• Torn Page Detection = On

• Auto Shrink = On

You only need to apply this procedure to the MPWEB database. You do not need to apply this procedure to the MPWEB-Slave-##### database.

Procedure

Complete these steps:

1. Open a command prompt window and issue the osql command to log in to the SQL server (replace userid and password with the appropriate values):

   C:\osql -U userid -P password
   
   

2. Issue the sp_helpdb command to see the current properties of the 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

   In this example, Recovery mode is set to full, and Torn Page Detection and Auto Shrink are not configured on this database.

3. Issue the alter database command to modify 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

4. If you are already low on disk space because the database file is very large, you can issue the shrinkdatabase command to force an immediate database shrink. This command removes empty space in the database files.

   This example decreases the size of the files in the MPWEB database to allow 10 percent free space:

   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.

5. You can issue the sp_helpdb command to check the properties and size of MPWEB database again.

   1> sp_helpdb MPWEB
   2> go
   1> exit
   

NetPro Discussion Forums - Featured Conversations

Related Information

• Voice Technology Support
• Voice and IP Communications Product Support
• Recommended Reading: Troubleshooting Cisco IP Telephony
• Technical Support - Cisco Systems