Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Fatal error 824 Expand / Collapse
Author
Message
Posted Wednesday, May 16, 2007 9:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:06 AM
Points: 146, Visits: 26

Im using sql2005 and in a simple query in the mngt studio return the error:

Msg 21, Level 24, State 1, Line 1
Warning: Fatal error 824 occurred at May 16 2007 11:07AM. Note the error and time, and contact your system administrator.

Someone know what is this error and how to fix it ?

Thanks

 




Post #366410
Posted Thursday, May 17, 2007 6:52 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 11:13 AM
Points: 15,527, Visits: 27,909

You got trouble in River City. According to MS:

The 824 error indicates that a logical consistency error was detected during a read. A logical consistency error is a clear indication of actual damage and frequently indicates data corruption caused by a faulty I/O subsystem component.

 

Time to get kicking with DBCC. I hope you've been testing your backups on a regular basis.



----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #366766
Posted Thursday, May 17, 2007 6:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 18, 2012 1:30 PM
Points: 102, Visits: 34

I have seen it before.

Right click on My Computer icon, select manage, Open the Event Viewer Tree, Select Application and check there for the time of the error to see what happened to your system. If nothing there then do the same on the SQL Server Machine is connected remotely.

 

Post #366767
Posted Tuesday, November 18, 2008 10:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 9, 2014 2:56 PM
Points: 1, Visits: 15
- hacer new query en master.
- alter database dbname set emergency
- ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- dbcc checkdb ('dbname', repair_allow_data_loss)
- alter database dbname set multi_user

saludos
Post #604586
Posted Tuesday, November 18, 2008 2:46 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 5:51 AM
Points: 6,266, Visits: 2,028
mobile (11/18/2008)
- hacer new query en master.
- alter database dbname set emergency
- ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- dbcc checkdb ('dbname', repair_allow_data_loss)
- alter database dbname set multi_user

saludos


If you decide to repair_ALLOW_DATA_LOSS be warned that you may not like the results.

My advice is to check first if the problem is in NC indexes pages which you can drop/recreate
If that is not the case you should try to use backups to get the data back.
If you just don't care about the data then doing as posted above may be OK.

In any instance check your hardware !!!



* Noel
Post #604719
Posted Tuesday, November 18, 2008 7:12 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 42,466, Visits: 35,530
mobile (11/18/2008)
- hacer new query en master.
- alter database dbname set emergency
- ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- dbcc checkdb ('dbname', repair_allow_data_loss)
- alter database dbname set multi_user

saludos


Repair should NOT be a first thing tried. As the name implies, it looses data. Not maybe. Not perhaps. It will cause data loss.

Please run the following and post the results
DBCC CHECKDB(< Database name > ) WITH NO_INFOMSGS



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #604797
Posted Wednesday, March 24, 2010 12:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 30, 2010 6:29 AM
Points: 16, Visits: 126
Find out what is causing the error, then do a dbcc checktable, odds are an index is out of whack, rebuild indexes on that table.


Post #889234
Posted Wednesday, March 24, 2010 1:40 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 42,466, Visits: 35,530
Considering that this thread is almost 3 years old, I'm guessing the OP has come right somehow.

Rebuilding indexes is not a way to fix corruption. It might (read might) make the problem disappear, but that's because rebuilding an index deallocates pages. If the damaged page is deallocated, the error appears to go away, but it wasn't fixed.

Take a look at this article. http://www.sqlservercentral.com/articles/65804/



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #889305
Posted Thursday, April 1, 2010 12:38 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:05 AM
Points: 500, Visits: 725
Nice article Gail.Thks.

Regards,
Saravanan
Post #894457
Posted Thursday, April 1, 2010 5:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:06 AM
Points: 146, Visits: 26
Thank you very much to all for your contribution.
During these years, the server has been changed and the sql server has been migrated to 2008.




Post #894616
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse