This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 23%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK9%3C/text%3E%3C/svg%3E)
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
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
@kumar-9444 , Agree with Leon, we can follow Kevin's blog to clean the database. Meanwhile, we also suggest to check if there's any not used MP installed in our environment. If yes, try to remove them as well.
Hope it can help.
MP means??? will follow Kevins blog
MP = Management Pack.
@kumar-9444 ,, How's everything going? If there's any update, feel free to let us know.