Wednesday, February 1, 2012

Download OM2007_MP_ExSrvr2003.doc [ Exchange Server 2003 Management Pack Guide] for Operations Manager 2007


Today i was looking for Management Pack Guide for “Exchange Server 2007” but not able to find it anywhere. The Microsoft links to the guide are not working anymore.

Somehow i manage to find the Guide and saved it on my Dropbox folder.

You can download “Management pack Guide for Exchange Server 2003” from 



Aman Dhally

How to change the Default retention period of ACS Database of SCOM.


What is Retention Period of database?

Once a day database when database grooming run it removed the data in ACS Database which is older then number of days specifies in database retention option.

My Problem: By default database retention period is of 14 days, but when i installed the ACS Services i choose to keep the database for 60 days and the drawback is my hard-disk starting filling up very quickly. Then i decide to change the Database retention period from 60 days to 30 days.

Lets do it.

First Login to your “SQL Server” using your “SQL Server Management Studio” .

01-02-2012 16-44-33

Browse to your “ACS Database” mine is “OperationsManagerAC” and click on “dbo.dtconfig” table.

01-02-2012 16-45-03

The retention day option is saved under (ID 6) in the “dbo.dtconfig” table of the ACS Database.

To change the setting, right click on “dbo.dtconfig” table and choose “Edit Top 200 Rows”.

01-02-2012 16-45-26

You can see that the value of ID 6 is 61, now lets change it to 31, {

01-02-2012 16-45-38

I change the value of ID-6 to  “31”.  and now run the same “Edit 200 row” query again.

01-02-2012 16-46-01

and you will saw that value is successfully saved as  “31” …

01-02-2012 16-46-42


That’s all


aman dhally