Results 1 to 3 of 3

Thread: Table Corrupt

  1. #1
    Join Date
    Jun 2006
    Posts
    10

    Unanswered: Table Corrupt

    Hi

    help me !

    TABLE: dbo.tran OBJID = 2000166321
    INDID=1 FIRST=117440 ROOT=117641 SORT=1
    Data level: 1. 64751 Data pages allocated and 8094 Extents allocated.
    Indid : 1. 908 Index pages allocated and 114 Extents allocated.
    INDID=2 FIRST=158944 ROOT=129485 SORT=0
    Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=144792; page# pointing to this page=140942; previous page# indicated in this page=137551)
    Page linkage traversed with BAD PREV pointers for OBJID 2000166321 INDID 2, processed 15035 pages
    TOTAL # of extents = 8208

    Statistical information for this run follows:
    Total # of pages read = 81157
    Total # of pages found cache = 2581
    Total # of physical reads = 19116
    Total # of saved I/O = 59460

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    BCP out tyhe data using INDID=1 then just drop and create the non-clustered index.

  3. #3
    Join Date
    Jun 2006
    Posts
    10
    Thankx

    but i tried bcp out it outs records upto that corrupted page and gives message & comes out .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •