Solved

SCOM 2012 R2 Data Warehouse woes...

Posted on 2013-12-12
3
1,480 Views
Last Modified: 2013-12-16
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.
0
Comment
Question by:ZelleIT
  • 2
3 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 39720644
What does the DBCC CheckDB show.
Try CHECKDB ('database_name') WITH NO_INFOMSGS, ALL_ERRORMSGS
Let it finish, and post your errors here as a text file.

Regards Marten
0
 

Author Comment

by:ZelleIT
ID: 39721740
No results returned, just the below messages:

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.
0
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 39722260
I'm sorry to say that you most likely had a failure of hardware. Probably a disk outage.
Your database seems corrupt.

Now it's time to pull foreward your DR plan. I e, what do we loose in form of transaction if we use the backup/restore plans that you hopefully have designed. Compared to what your potential loss is if you determine to attempt a repair, allowing dataloss.

Time is a factor. A repair can be very timeconsuming. And given your DBCC reply code, it might not even be possible.

This link: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/58d12ee6-10f7-4f7c-a506-8c5ac1c3928d/error-when-running-dbcc-checkdb
will give some inputs.

Please understand, a restore will not make your day, even if this is acceptable or even good regarding to the data, you need to pursuit the root cause. If you do not you will be hit again and again. It's time to analyze eventlogs and errorlogs. Maybe even send stack dumps to Microsoft. Don't skip this step.

Regards Marten
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Server Log File Space 6 33
sql query 7 34
sql calculate averages 18 24
Server Infected with Malware 20 34
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now