How to purge old data in OperationsManagerDW 2016 database??

kumar-9444 121 Reputation points
2021-09-05T11:09:29.63+00:00

OperationsManagerDW (SCOM 2016) database size is around 850GB. The data which is older than 1year needs to be purged. How to purge the the old data? This instance have other databases as well. Is there any risks involved ?

SQL server version 2016 Enterprise edition

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,436 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Leon Laude 85,701 Reputation points
    2021-09-05T11:38:22.413+00:00

    Hi @kumar-9444 ,

    Here are two excellent articles from Kevin that should help you out:

    ----------

    If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

    Best regards,
    Leon

    1 person found this answer helpful.