SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Fatal error 824


Fatal error 824

Author
Message
sergio hi
sergio hi
SSC Veteran
SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)

Group: General Forum Members
Points: 252 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





Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)SSC Guru (162K reputation)

Group: General Forum Members
Points: 162691 Visits: 33199

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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Camilo Torres
Camilo Torres
SSC Eights!
SSC Eights! (882 reputation)SSC Eights! (882 reputation)SSC Eights! (882 reputation)SSC Eights! (882 reputation)SSC Eights! (882 reputation)SSC Eights! (882 reputation)SSC Eights! (882 reputation)SSC Eights! (882 reputation)

Group: General Forum Members
Points: 882 Visits: 45

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.


mobile
mobile
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 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
noeld
noeld
SSC-Dedicated
SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)

Group: General Forum Members
Points: 38820 Visits: 2051
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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)

Group: General Forum Members
Points: 414390 Visits: 47128
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, MVP, M.Sc (Comp Sci)
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


pamarant
pamarant
SSC-Enthusiastic
SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)SSC-Enthusiastic (146 reputation)

Group: General Forum Members
Points: 146 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.



GilaMonster
GilaMonster
SSC Guru
SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)SSC Guru (414K reputation)

Group: General Forum Members
Points: 414390 Visits: 47128
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, MVP, M.Sc (Comp Sci)
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


Saravanan T
Saravanan T
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1272 Visits: 801
Nice article Gail.Thks.

Regards,
Saravanan
sergio hi
sergio hi
SSC Veteran
SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)

Group: General Forum Members
Points: 252 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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search