Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: strange error -> msg629,level 21

    there is a table in SQLSERVER6.5. PK consists of 2 columns
    (cluster index) . there are 100000 records in that table .

    case1:

    set rowcount = 1000
    go
    delete from <mytable>

    everything is OK

    case2:
    set rowcount = 6000
    delete from <mytable>
    Error:
    msg629,level 21, state1, line2 , fatal attempt to delete clustered index .......

    after issue "DBCC DBREINDEX" , the error is disappear .

    I am very confused what happen in the database . Is this a bug in SQL server 6.5 ? And what's the story behind it ?
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Your index was corrupted and you repaired it, that's all.
    Do you have enough log space reserved ?

  3. #3
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63
    Could you tell me how many chance will it happen again and what's the
    actual cause
    Oracle is an ocean . I am just a little fish

  4. #4
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Many ways how to corrupt a database.
    But if an error occurs, I would create a new database by a script and transfer data to it. Just to be sure the error is not caused by my physical file.

Posting Permissions

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