If I set the Retain Syslog messages in the database for 120 days, does theSyslog viewer overwrite the messages after the 120th day? My SQL database is getting very large and I only need to keep the messages for 120 days.
Thank you for the help. I will give that a try
If you set it to 120 days, when database mainteance runs, it will delete everything older than than 120 days, and the data won't show anywhere anymore.
Does the database maintenance run on it's own or do I have to run it? If it has to be done manually can it be automated?
Please see page 224-228 of the Orion NPM Administrator Guide for further information, but here is a snippet:
The primary tasks that are available for maintaining a SQL database are data summarization and database compaction. Data summarization occurs automatically as a part of the nightly maintenance program. You can also run database maintenance on demand from the System Manager or from the Windows Start menu.
