Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-16 : 11:55:43
|
| Lee writes "I'm currently running on ss7 ( no patches applied ) & have got the following errors on some tables : ERROR 5180Could not open FCB for invalid file ID %d in database '%.*ls'. Table or database may be corrupted1, What exactly is "FCB"2, The Knowledge Base article states the workaround is by installing sp3 but I haven' the time to test & want to fix the problem asap.Please help asapLee" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-16 : 13:38:33
|
| An FCB is a file control block and is used by NT/Win2K for file access. If the file is indeed corrupted your entire database is at risk.First, see if you can perform a FULL database backup. Whether it succeeds or fails, then try DBCC CHECKDB with the REPAIR_REBUILD option (see Books Online for more details on the syntax). Once that's done see if the database is accessible.If not, try running CHKDSK or Scandisk or whatever disk repair utility you use on the affected drive.If none of this works, you'll have to apply SP3 (which you should do anyway, it doesn't take that long and it fixes a load of bugs). MAKE SURE you make full backups of all of your databases before you apply it.Edited by - robvolk on 12/16/2001 14:10:17 |
 |
|
|
|
|
|
Allocation Errors - 5180