Solved

How do I fix MSSQL$SBSMONITORING Event ID 824?

Posted on 2009-04-13
2
2,314 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?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

937 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

10 Experts available now in Live!

Get 1:1 Help Now