File Control Bank (FCB) errors (was: Can't get Update Query to work)

query

use [row]

update dbo.fpts_all

set dbo.fpts_all.relid = dbo.fpt_partid_relloc_mapping.relloc

from dbo.fpt_partid_relloc_mapping join

dbo.fpts_all

on dbo.fpt_partid_relloc_mapping.partid = dbo.fpts_all.partid

ends error

msg 0, level 11, state 0, line 0

a severe error occurred on the current command.  the results, if any, should be discarded.

i re-worked (rearranged) query

use [row]

update  dbo.fpts_all

set     dbo.fpts_all.relid  = dbo.fpt_partid_relloc_mapping.relloc

from    dbo.fpts_all  join    dbo.fpt_partid_relloc_mapping

on      dbo.fpts_all.partid = dbo.fpt_partid_relloc_mapping.partid

and ends in

msg 5180, level 22, state 1, line 3

could not open file control bank (fcb) for invalid file id 256 in database 'row'.

verify the file location. execute dbcc checkdb.

that doesn't make sense!!! can explain, please! tried similar queries before , worked fine. what's going on here???

thanks, chris

chris,

it sounds may have corruption in metadata, or memory or io issues.  know sounds bit vague, that's find information provided.  start running dbcc checkdb no_infomsgs, all_errormsgs on database in question, system databases.  if checkdb returns anything, please post here , we'll try you.  if doesn't work, may want try memory , io scans see if there hardware problems.  i'm going move post on "disaster recovery", , rename it, so it attracts more appropriate attention.

---

aaron alton | thehobt.blogspot.com

SQL Server  >  SQL Server High Availability and Disaster Recovery