Results 1 to 4 of 4

Thread: Table Currupt

  1. #1
    Join Date
    Sep 2003
    Location
    India
    Posts
    17

    Question Unanswered: Table Currupt

    Whereever i'm running a select statement on a table if found error stating

    ERROR:605, Severity:21
    Attempt to Fetch logical page <page no> in database <db name> belongs to objects '0' not to object <table name>

    I don't want to drop the table because it has data that's not backedup.

    Tell me if there is other ways to do it.


    Rgds

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Error: 605 is a hard fault, can also be a result of hardware errors.

    Dropping the table does not necessarily resolve the issue. You can attempt to bcp out the whole database and salvage as much data as possible.

  3. #3
    Join Date
    Sep 2003
    Location
    India
    Posts
    17

    Table Currupt

    Hello

    Is it problem of Hard disk Bad sectors.


    Regards

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: Table Currupt

    Take a look there : you will perhaps find a way to save your table (it's unfortunately in French, but ... T-SQL is T-SQL)

Posting Permissions

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