How do I fix MSSQL$SBSMONITORING Event ID 824?

Posted on 2009-04-13
Medium Priority
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
Event ID: 824
Level: Error
User: System
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.
Question by:oszur
LVL 13

Expert Comment

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.


Accepted Solution

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

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Suggested Courses

624 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