January 1, 2013 at 9:38 pm
Hi,
Often am getting logical consistency error in one my production server. Recently i did DBCC with allow dataloss option, to correct the inconsistency. Now i see the below error in the database.
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:6743211; actual 0:0). It occurred during a read of page (1:6743211) in database ID 11 at offset 0x00000cdc956000
Again do I need to repair the database? Why this inconsistency is happening often?
Thanks,
Dev.
January 2, 2013 at 2:37 am
Please run the following and post the full and complete unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
If you're getting repeated corruptions, there's something wrong in the IO subsystem. Check logs, check drivers, firmware, etc.
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
January 2, 2013 at 10:58 pm
Am unable to do DBCC checkdb also.
It is erroring with temp db out of space.
Month back , i tried to run dbcc when my application was down. That time i got the output.
Shall i run with tablock option? Is there any other option where i can perform DBCC without taking application down. Any Option other than taking the db in single user mode.
Thanks,
Dev.
January 3, 2013 at 12:56 am
Post the output you got (everything). I can't tell anything from a description of the messages. (no, not with tablock)
Repair is not the recommended way to fix corruption, it's for cases where there's no clean backup. The recommended fix for corruption is to restore a clean backup
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
January 3, 2013 at 3:41 am
This is the output for the DBCC checkdb command
I executed DBCC checkdb (db_name) with all_errormsgs;
Msg 8967, Level 16, State 216, Line 1
An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
DBCC results for <database_name >
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
CHECKDB found 0 allocation errors and 0 consistency errors in database <database name>
January 3, 2013 at 6:00 am
Restore from a good backup
And do some investigation of that IO subsystem, maybe move the DB elsewhere (different disks)
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
January 3, 2013 at 8:04 pm
The problem is the good backup of this database got expired.
Kindly clarify my below questions
When you say move the DB to different disk? I have nearly 9 DB's data files on the same drive.Do I need to move all the 9 DB's data file to other drive??
Even other db's mdf files stay in this drive healthy?? Why this is getting corrupted?
January 4, 2013 at 12:38 am
Whenever I suspect the IO system to be unreliable, I move all DB stuff that is on it !
No doubt.
I wouldn't take the risk of down time or losing data because of HW failures of an IO system that is unreliable.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 4, 2013 at 2:18 am
devanandiiway (1/3/2013)
The problem is the good backup of this database got expired.
Then you have a serious problem, because there's no way you can repair this error. You need to restore a clean backup here.
When you say move the DB to different disk? I have nearly 9 DB's data files on the same drive.Do I need to move all the 9 DB's data file to other drive??
Well that or risk the others becoming corrupted
Even other db's mdf files stay in this drive healthy?? Why this is getting corrupted?
As I said, IO subsystem problems of some form. You need to check the IO subsystem (everything from the drivers to the disks) and look for problems.
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
January 4, 2013 at 3:59 am
Do you mean that I need to move all the mdf from that drive?
Is there anyway I can repair the hardware? Since it is occuring often.
January 4, 2013 at 5:12 am
devanandiiway (1/4/2013)
Do you mean that I need to move all the mdf from that drive?
Unless you are happy that the databases on there may potentially become corrupted, yes. That's like asking if you should keep critical data on a drive that's giving known problems. Personally I wouldn't, but if you don't care if that critical data is lost, then keep it there.
Is there anyway I can repair the hardware? Since it is occuring often.
Maybe. Depends what's wrong with it. You need to check the IO subsystem (everything from the drivers to the disks) and look for problems.
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
January 13, 2013 at 1:02 am
I will move all my mdf files to other drive and let you know.
Thanks,
Dev
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply