Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) SQL Server detected a logical consistency-based I/O error RE: SQL Server detected a logical consistency-based I/O error

  • January 10, 2012 at 3:21 am

    #1430970

    GilaMonster (1/10/2012)

    For future reference, repair should be the absolute last resort for corruption, no a knee-jerk first thing done.

    Hi Gail, what could be alternative solution to aviod data loss? when facing this type of error occurred in database.

    I am facing first time this type of IO Error in CHECKDB. Eeven though not able to count all the records that particular table for due to 823 - a hard IO error.. So I am decided to ran DBCC CHECKTABLE ('Tablename', REPAIR_ALLOW_DATA_LOSS) command. after ran that those error was resolved.

    thanks

    ananda