Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How do I fix MSSQL$SBSMONITORING Event ID 824?

Posted on 2009-04-13
2
Medium Priority
?
2,422 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
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 give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

636 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