Support SQL Script For SCOM R2 CU#7 Data Warehouse Database

Yesterday Microsoft released a support script for the SCOM R2 CU#7 Data Warehouse database which resolves these issues:

• Data warehouse fails to drop partitions, and limit is reached.
• Availability Time report shows monitoring resource available even though it is not.

DON’T RUN THIS SUPPORT SCRIPT AGAINST ANY OTHER SCOM DATA WAREHOUSE DATABASES SINCE THIS SCRIPT IS ONLY MEANT FOR SCOM R2 CU#7.

This script for SCOM R2 CU#7 can be downloaded from here.

Some additional advice
Before you run this script, make a backup of BOTH SCOM R2 CU#7 databases, meaning not only the Data Warehouse database but the Operational database as well. When you’ve to roll back, both SCOM R2 databases have to be of the same time frame. Otherwise changes are you end up with synchronization issues.