InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 15:40:42 GMT20http://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxI will move all my mdf files to other drive and let you know. Thanks,DevSun, 13 Jan 2013 01:02:02 GMTdevanandiiwayhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspx[quote][b]devanandiiway (1/4/2013)[/b][hr]Do you mean that I need to move all the mdf from that drive?[/quote]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.[quote]Is there anyway I can repair the hardware? Since it is occuring often.[/quote]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.Fri, 04 Jan 2013 05:12:53 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxDo 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.Fri, 04 Jan 2013 03:59:52 GMTdevanandiiwayhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspx[quote][b]devanandiiway (1/3/2013)[/b][hr]The problem is the good backup of this database got expired. [/quote]Then you have a serious problem, because there's no way you can repair this error. You need to restore a clean backup here.[quote]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?? [/quote]Well that or risk the others becoming corrupted[quote]Even other db's mdf files stay in this drive healthy?? Why this is getting corrupted?[/quote]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.Fri, 04 Jan 2013 02:18:46 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxWhenever I suspect the IO system to be unreliable, I [b]move all DB stuff that is on it[/b] !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.Fri, 04 Jan 2013 00:38:40 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxThe problem is the good backup of this database got expired. Kindly clarify my below questionsWhen 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?Thu, 03 Jan 2013 20:03:59 GMTdevanandiiwayhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxRestore from a good backupAnd do some investigation of that IO subsystem, maybe move the DB elsewhere (different disks)Thu, 03 Jan 2013 06:00:25 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxThis is the output for the DBCC checkdb commandI executed DBCC checkdb (db_name) with all_errormsgs;Msg 8967, Level 16, State 216, Line 1An 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 1Check 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>Thu, 03 Jan 2013 03:41:02 GMTdevanandiiwayhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxPost 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 backupThu, 03 Jan 2013 00:56:49 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxAm 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.Wed, 02 Jan 2013 22:58:54 GMTdevanandiiwayhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxPlease run the following and post the full and complete unedited output.[code]DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS[/code]If you're getting repeated corruptions, there's something wrong in the IO subsystem. Check logs, check drivers, firmware, etc.Wed, 02 Jan 2013 02:37:49 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401646-265-1.aspxHi,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 0x00000cdc956000Again do I need to repair the database? Why this inconsistency is happening often? Thanks,Dev.Tue, 01 Jan 2013 21:38:10 GMTdevanandiiway