SCOM 2012 R2 Data Warehouse woes...
Posted on 2013-12-12
I'm currently running a single Management Server deployment of SCOM 2012 R2. 70 servers monitored, no distributed apps or anything fancy like that. I've been getting a ton of errors related to the Data Warehouse. After attempting multiple resolutions, I've decided that the easiest path will be to rebuild the Data Warehouse from the ground up. We're not worried about losing data.
A GlobalKnowledge instructor told me that the easiest method might be to simply rename the existing database, then to create a new one named the same as the old one.
If anyone has any insight on this, I would appreciate it. I would greatly prefer to not have to start completely over with my SCOM deployment if at all possible, and I'm not enough of a DBA to know whether the database can be fixed. I did try to run a DBCC on it, which fails.