[msmom] Clear MOM/SCOM DBs [g7yaw3]
From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf Of Kevin Holman
Sent: Monday, June 29, 2009 3:05 PM
To: msmom@lists.myitforum.com
Subject: RE: [msmom] Clear MOM/SCOM DBs
Then simply shrink the DB’s in SQL, using the shrink commands – look these up in Books Online for the syntax, or use the UI.
Note: Both MOM and SCOM OpsDB should retain AT LEAST 50% free space in the database, so do not shrink the DB file size below this.
For the reporting warehouse DB’s, you need 1.5x the largest table size as free space – to be able to reindex the DB.
If you need to groom data to free up internal DB space, then you first need to modify retention settings for each DB. Operational in the UI. Warehouse in the database table, or using the tools provided in blogs.
If you need help with the former or the latter, be specific on which one. But the product documentation has all you need to know on these…. The tools can be found with a few Bing searches.
From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf Of JRIT
Sent: Monday, June 29, 2009 1:57 PM
To: msmom@lists.myitforum.com
Subject: Re: [msmom] Clear MOM/SCOM DBs
I need free up disk space :)
2009/6/29 Kevin Holman <Kevin.Holman@microsoft.com>
I still don’t follow you:
Do you mean – free up disk space – making the database sizes smaller?
Or do you mean groom out data – so there is less data retained in the databases?
My environment has MOM and SCOM, so I need to "clear some data" to make this more less.
==============
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/
Trackbacks
No Trackbacks
Comments
No Comments
