FAQShop.com: What Happens to MOM if I Shut Down the MOM Database?

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

We have our MOM database installed on a separate SQL 2000 server. This SQL server needs to be shutdown for unrelated maintenance. What will happen once the MOM server is unable to contact the database? Will the alerts continue to function, will the performance data queue up somewhere until the database is back on-line, will this data automatically be updated in the database once it is available, and will be the notification groups be flooded with alerts?

Is there a proper sequence to follow when the MOM SQL database is being shut down?

Contributed By: Ugo Corti
If the MOM database drops from the network then the events and alerts are stored on the DCAM(s). The DCAM(s) have Persistent Queue Files. The PQFs will fill up after so many days but by then you should have the MOM database up and running. As well if the MOM agents cannot communicate with the DCAM(s) they to will store the information locally until communication is re-established to the DCAM(s).