Table Error : IAM page and Could not open FCB

• Umesh-167481

  Newbie

  Points: 1

  More actions

  June 24, 2008 at 1:19 am

  #70868

  Hi All

  I have a database in SQL 7.

  In this database some month back i got problem with some tables.

  It was saying "Could not open FCB for invalid file ID 0 in database. Table or database may be corrupted" for some table.

  I can not delete those tables

  SO i let those tables as it is there and create another table with same structure.

  These tables are used for reports, and data in it is inserted and deleted while showing reports.

  All other functions are working file like taking back up etc.

  Just is that i can not delete those tables.

  Now i am trying to restore this database in SQL 2000.

  It starts restoring database, but while restoration is almost ending it gives error as below

  I am getting error as "Table Error : IAM Page is out of range of this database."

  How can i restore the database.

  Is the problem related with those tables which are corrupted ?

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  June 24, 2008 at 2:01 am

  #833175

  On your 7 database run DBCC CHECKDB or run DBCC CHECKTABLE and CHECKALLOC on the table that is causing the problem.

  This may fix the problem, then back it up, and restore it on 2000.

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software