Shrink/Truncate Compellent Enterprise Manager compmsadb Database

Hi ERICB_SP,

Did you find solution about this issue? I am trying to find a solution.

Shrinking the Enterprise Manager database is a 2 step process:

1. Reduce the amount of time to store entries

2. Shrink the database Reducing the amount of time to store entries in the Enterprise Manager Data Collector

1) Double-click on the Data Collector icon.

2) Enter your password. Click Log In.

3) Click Limits

4) Reduce the number of days Reporting Data is being stored for by half

Example:

Log Lifetime: 30 Days

Alert Lifetime: 45 Days

Reporting Data Lifetime: 180 Days

5) Click Apply changes

Shrinking the Enterprise Manager database

The Enterprise Manager database is located at C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data by default:

Open the Microsoft SQL Server Management Studio. Login. This will require membership in the sysadmin fixed server role or the db_owner fixed database role.

Right-click on the compmsadb and select Properties

Select Files and check to see how large the database is and if there are any growth restrictions set

If there are any growth restrictions set then change these to allow for additional growth of the compmsadb.   Next, right-click on the compmsadb database. Select Tasks -> Shrink -> Files

This task will prompt you for settings. Select to shrink the database to the minimum size shown. It may take some time for the collected data to be released. Once the database has been shrunk it will show the size you had selected to reduce it to.

Reference Pages

Shrink a Database http://msdn.microsoft.com/en-us/library/ms189035.aspx Go to this page and select your version of Microsoft SQL

Shrink a File http://msdn.microsoft.com/en-us/library/ms190757.aspx Go to this page and select your version of Microsoft SQL