Post reply

Creating Index: Got Error

  • December 5, 2007 at 5:57 pm

    #119857

    Dear All,

    When I run this statement it gives me an error.:

    CREATE

    INDEX [NC_DateAcctTotal] ON [dbo].[BilledPackages] ([pu_date], [acct_no], [delete_flag], [billing_weight_charge])

    WITH

    FILLFACTOR = 90

    ON [PRIMARY]

    ::::: ERROR ::::

    Server: Msg 823, Level 24, State 2, Line 1

    I/O error (torn page) detected during read at offset 0x000006d5f2c000 in file 'E:\MSSQL\Data\Management_Data2_Data.NDF'.

    Connection Broken

    Please let me help in this issue, it's an urgent.

    I appreciate for your help.

    Thanks & Regards,

    KP

  • December 6, 2007 at 12:02 am

    #757533

    Do you have a recent database backup? How critical is the data in that table?

    You have some corruption in your data file, probably a data page that's damaged.

    Run the following and see what it returns in terms of errors. You may also wat to run a full CheckDB to see if there are issues elsewhere.

    DBCC CHECKTABLE ('BilledPackages') WITH ALL_ERRORMSGS, NO_INFOMSGS

    For some info on the error, see here. 823 is a hard IO error. Is not a good thing to have

    Also see this on advice for fixing, especially what not to do.

    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

  • December 6, 2007 at 7:07 am

    #757646

    Thanks for your reply..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply