troubleshooting Question

SCOM 2012 R2 Data Warehouse woes...

Avatar of ZelleIT
ZelleIT asked on
Microsoft SQL ServerSSRSWindows Server 2012
3 Comments1 Solution1776 ViewsLast Modified:
Hello all.
 
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.
ASKER CERTIFIED SOLUTION
Marten Rune
SQL Expert/Infrastructure Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros