I have inherited a MOM 2005 environment and its unmanageable. The Onepoint DB is 50 GB and Systemcenterreporting DB is around 700 GB (yes 700 !!) I am going through all the normal cleanup process like changing the period for which SCDW stores data in DB. It was configured 900 days and by changing it 5 days at a time and running grooming I have reached to 370 days. my goal is to keep 100 days worth of data eventually. Right now I am tired of decreasing it 5 days at a time and running grooming. I would like to just drop whole of data and start from scratch, how do I do it.
I do not want to uninstall and reinstall reporting services.
What are my options ?