Solved

How do I fix MSSQL$SBSMONITORING Event ID 824?

Posted on 2009-04-13
2
2,343 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

749 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