Getting this "Error: 5180, Severity: 22, " in SQL Error log

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neeraj - 01 Jul 2008 22:30 GMT

My Previous thread for this error got archived. In nut shell, I ran the
checkalloc,checkcatalog, checkconstraints. I also ran checktable on all
tables. Everything was clean. I am still getting these errors. I am open to
any suggestions anybody might have. I am planning to open a case with MS for
this. Will update the post again with the information I find from the case.

http://newsgroups.cryer.info/microsoft/public.sqlserver.server/200805/21/0805237
7049.html

-Neeraj

Reply to this Message

Russell Fields - 01 Jul 2008 23:19 GMT

Neeraj,

Is this the message that you are still getting?

2008-05-20 16:23:04.05 spid839 Could not open FCB for invalid file ID 11
in database 'tempdb'..

In which case, do you actually have a file id 11 for tempdb? How many files
make up tempdb? And, if you had defined 11 files, is the 11th file still
there on disk?

USE TEMPDB
EXEC SP_HELPFILE

Can you ALTER DATABASE to remove the file from tempdb?

RLF

> My Previous thread for this error got archived. In nut shell, I ran the
> checkalloc,checkcatalog, checkconstraints. I also ran checktable on all
[quoted text clipped - 6 lines]
>
> -Neeraj

Reply to this Message