MOM Database

• Duplicate Entries Added to MOM when Server Brought Up in Active Directory Restore Mode [7/8//03]

• Extracting Operator Information from the OnePoint Database [13/6/03]

• How Do I Delete Old Systems from the MOM Database? [25/6/03]
• How Do I Move the OnePoint Database to a Different Server? [12/01/04]
• Implementing a Second SQL Server to Archive MOM Performance Data [31/1/03]
• My Database Keeps Growing and I Can’t Work out Why? [4/3/03]
• Should I use Mixed or Integrated Security for MOM? [21/03/05]
• What Happens to MOM if I Shut Down the MOM Database? [02/04/04]
• Which Table is Causing My Database to Grow? [17/6/03]
• Who Should Own the OnePoint Database? [15/8/03]

Duplicate Entries Added to MOM when Server Brought Up in Active Directory Restore Mode

Contributed By: Cliff Hobbs [MVP SMS]
If you’re noticing duplicate entries in your MOM database for every server bought up in Active Directory Restore Mode then here’s some advice… [Go to the article]
 

Extracting Operator Information from the OnePoint Database

From the microsoft.public.mom newsgroup
If you’re wondering how to extract such information then be careful as Microsoft don't support accessing the database tables directly, but here's a way of getting some of the information... [Go to the article]
 

How Do I Delete Old Systems from the MOM Database?

Contributed By: Cliff Hobbs [MVP SMS]
Quite a common FAQ this one.  Find out here... [Go to the article]
 

How Do I Move the OnePoint Database to a Different Server?

Contributed By: Travis Wright [MSFT]
Wondering how you can move the OnePoint database to a different server?.. [Go to the article]
 

Implementing a Second SQL Server to Archive MOM Performance Data

Contributed By: Cliff Hobbs [MVP SMS]
Can you implement an additional SQL Server to archive your MOM Performance Data? Well, here David Williams offers some advice...  [Go to article]
 

My Database Keeps Growing and I Can’t Work out Why?

From the microsoft.public.mom newsgroup
If your database keeps growing and growing and you can't work out why then the solution could be here... [Go to the article]
 

Should I use Mixed or Integrated Security for MOM?

Contributed By: Bill Hodghead [MSFT]
Wondering which SQL authentication mode you should use for MOM?..  [Go to article]
 

What Happens to MOM if I Shut Down the MOM Database?

Contributed By: Ugo Corti
You've got your MOM database hosted on a different box to MOM itself. So what happens to MOM if you need to take the database server offline for a while?..  [Go to article]
 

Which Table is Causing My Database to Grow?

From the microsoft.public.mom newsgroup
If you’ve upgraded to SP1 and found that your MOM database is now growing all of sudden then here’s some hints to help you… [Go to the article]
 

Who Should Own the OnePoint Database?

From the microsoft.public.mom.managementpack.sql newsgroup
So you’ve installed MOM but you’re unsure who should be the owner of the OnePoint database… [Go to the article]