Wednesday, February 1, 2012

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


  1. Replies
    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai

  2. Thanks For sharing nice article about database development services.
    Database Development Services in India


  3. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Online Training from India. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.
    JavaScript Online Training from India

  4. You blog post is just completely quality and informative. Many new facts and information which I have not heard about before. Keep sharing more blog posts.
    python training in chennai
    python course institute in chennai

  5. This is a nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
    Data Science Training in Chennai
    Data Science training in kalyan nagar
    Data science training in Bangalore
    Data Science training in marathahalli
    Data Science interview questions and answers
    Data science training in jaya nagar

  6. I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing.. Believe me I did wrote an post about tutorials for beginners with reference of your blog. 
    Best Devops online Training
    Online DevOps Certification Course - Gangboard

  7. Nice Article,Great experience for me by reading this info.thanks for sharing the information with us.keep updating your ideas.
    devops training in chennai | devops training in anna nagar | devops training in omr | devops training in porur | devops training in tambaram | devops training in velachery

  8. Nice Article,Great experience for me by reading this info.thanks for sharing the information with us.keep updating your ideas.
    AWS training in Chennai

    AWS Online Training in Chennai

    AWS training in Bangalore

    AWS training in Hyderabad

    AWS training in Coimbatore

    AWS training

  9. Good Post! , it was so good to read and useful to improve my knowledge as an updated one, keep blogging.After seeing your article I want to say that also a well-written article with some very good information which is very useful for the readers....thanks for sharing it and do share more posts likethis.

  10. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    devops online training
    best devops online training
    top devops online training