?
Solved

How do I fix MSSQL$SBSMONITORING Event ID 824?

Posted on 2009-04-13
2
Medium Priority
?
2,455 Views
Last Modified: 2012-05-07
SBS 2008 server is getting a bunch (15-40) of MSSQL$SBSMONITORING 824 errors in the Windows Application log about twice an hour (~30 minutes between each group). This has been happening since the system was installed. It is running on a Dell PowerEdge 2950. I have verified that the system BIOS, PERC Firmware and PERC drivers are all up to date. The system has no disk hardware issues that can be seen using OpenManage nor are there any other errors in any of the multitude of event logs on this system that indicate a HDD issue. The errors are exactly the same every time. Here are the specifics of the errors:

Log Name: Application
Source: MSSQL$SBSMONITORING
Event ID: 824
Level: Error
User: System
OpCode:
Logged: various dates & times
Task Category: (2)
Keywords: Classic
Computer: servername.domain.local

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xb4fd511e; actual: 0xb4fdd11e). It occurred during a read of page (1:1055) in database ID 5 at offset 0x0000000083e000 in file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SBSMonitoring.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
0
Comment
Question by:oszur
2 Comments
 
LVL 13

Expert Comment

by:St3veMax
ID: 24132634
This error suggests there is a corruption in one or more of your database tables.

Do as the error suggests; run a DBCC CheckDB on all databases and see what the report comes back with.

HTH
0
 

Accepted Solution

by:
oszur earned 0 total points
ID: 24132953
Thanks Steve. How do I do this?
1

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

840 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