SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Data Corruption » SOLUTION OF THE ERROR

SOLUTION OF THE ERROR Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
sakthivel.jeevan
Posted Thursday, October 29, 2009 11:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 02, 2009 11:22 PM
Points: 2, Visits: 3
Attempt to fetch logical page (1:110552) in database 10 failed. It belongs to allocation unit 4432555802624 not to 412557876723712.

I have the above error and also i find the error this is index corruption error. I deleted the index and then re-create the index after that i got same error so what can i do give m e solution please,,,,
Post #811359
GilaMonster
Posted Friday, October 30, 2009 1:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:52 PM
Points: 17,103, Visits: 12,204
Please run the following and post the full output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

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

Do you have a clean backup of this database? (a backup that doesn't have this corruption in it)

Gail Shaw

We walk in the dark places no others will enter
We stand on the bridge and none may pass
Post #811383
Silverfox
Posted Friday, October 30, 2009 2:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 27, 2009 5:32 AM
Points: 2,683, Visits: 1,003
Can you post what Gail has requested and if you have already tried to recreate the index, was it a non-clustered index.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #811399
zeitiadaisy
Posted Monday, November 02, 2009 12:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 01, 2009 11:55 PM
Points: 1, Visits: 0
How accurately can you read the buret? The calibration marks are probably 0.10 mL or 0.05 mL and you estimate the reading to the nearest 0.01 mL. You had to make 2 readings...initial volume and final volume. The buret is probably calibrated at 20 deg C. Was the temperature of the KCl solution 20 deg C? What is the calibration accuracy of the buret?

How accurately can you read the weight? (Again 2 readings...the empty beaker and the filled beaker). What is the sensitivity and accuracy of the balance?

Acai force max review
Post #812201
Silverfox
Posted Monday, November 02, 2009 3:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 27, 2009 5:32 AM
Points: 2,683, Visits: 1,003
Something makes me think the last post, is somehow not related to this topic, and possibly not even this forum perhaps

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #812274
GSquared
Posted Monday, November 02, 2009 6:54 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:24 PM
Points: 8,665, Visits: 4,943
zeitiadaisy (11/2/2009)
How accurately can you read the buret? The calibration marks are probably 0.10 mL or 0.05 mL and you estimate the reading to the nearest 0.01 mL. You had to make 2 readings...initial volume and final volume. The buret is probably calibrated at 20 deg C. Was the temperature of the KCl solution 20 deg C? What is the calibration accuracy of the buret?

How accurately can you read the weight? (Again 2 readings...the empty beaker and the filled beaker). What is the sensitivity and accuracy of the balance?


LOL!!! Very, very clever!

Silverfox Something makes me think the last post, is somehow not related to this topic, and possibly not even this forum perhaps


Take a look at the title of this thread. Oh, it's related all right. And about as much answer as the OP will get without more data.

- GSquared

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #812351
« Prev Topic | Next Topic »


Permissions Expand / Collapse

 
 
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use