I am getting the following msg when I run a select Query
on one of my newly created tables:

Server: Msg 5180, Level 22, State 1, Line 1
Could not open FCB for invalid file ID 0 in
database 'MyDB'. Table or database may be corrupted.

Connection Broken

I am running this in the query analyzer. It allows me to
query many other tables. I am also able to see entry for
this table in the SYSOBjects master table. I just can't do
any query on this particular table. Any suggestions?

Report this post to a moderator

Have you tried running dbcc checktable?
You may also want to see if the following applies in your
situation:
FIX: Error Message 5180 May Occur When You Retrieve Text or
Image Data (Q276043)
http://support.microsoft.com/defaul...b;EN-US;Q276043

-Sue

On Thu, 27 Jun 2002 15:07:18 -0700, "Mike" <ltear@yahoo.com>
wrote:

>I am getting the following msg when I run a select Query
>on one of my newly created tables:
>
>Server: Msg 5180, Level 22, State 1, Line 1
>Could not open FCB for invalid file ID 0 in
>database 'MyDB'. Table or database may be corrupted.
>
>Connection Broken
>
>I am running this in the query analyzer. It allows me to
>query many other tables. I am also able to see entry for
>this table in the SYSOBjects master table. I just can't do
>any query on this particular table. Any suggestions?

Report this post to a moderator

I ran the dbcc checktable. It came back with the following
error msg. Is there any way to repair this? Also is there
a query to run and fix all the currpted tables? I have
about 7000 table, some of which are similarly corrupted.

Server: Msg 7965, Level 16, State 2, Line 1
Table corrupt: Could not check object ID 263984317, index
ID 0 due to invalid allocation (IAM) page(s).
Server: Msg 8968, Level 16, State 1, Line 1
Table Corrupt: IAM page (1:955241) (object ID 263984317,
index ID 0) is out of the range of this database.
DBCC results for 'MyTable'.
There are 0 rows in 0 pages for object 'MyTable'.
CHECKTABLE found 0 allocation errors and 2 consistency
errors in table 'MyTable' (object ID 263984317).
repair_allow_data_loss is the minimum repair level for the
errors found by DBCC CHECKTABLE (MyDB.dbo.MyTable ).


>-----Original Message-----
>Have you tried running dbcc checktable?
>You may also want to see if the following applies in your
>situation:
>FIX: Error Message 5180 May Occur When You Retrieve Text
or
>Image Data (Q276043)
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q276043
>
>-Sue
>
>On Thu, 27 Jun 2002 15:07:18 -0700, "Mike"
<ltear@yahoo.com>
>wrote:
>
>>I am getting the following msg when I run a select Query
>>on one of my newly created tables:
>>
>>Server: Msg 5180, Level 22, State 1, Line 1
>>Could not open FCB for invalid file ID 0 in
>>database 'MyDB'. Table or database may be corrupted.
>>
>>Connection Broken
>>
>>I am running this in the query analyzer. It allows me to
>>query many other tables. I am also able to see entry for
>>this table in the SYSOBjects master table. I just can't
do
>>any query on this particular table. Any suggestions?
>
>.
>

Report this post to a moderator

Check books online on DBCC CHECKDB and the repair options.

-Sue

On Fri, 28 Jun 2002 09:46:51 -0700, "mike" <ltear@yahoo.com>
wrote:

>I ran the dbcc checktable. It came back with the following
>error msg. Is there any way to repair this? Also is there
>a query to run and fix all the currpted tables? I have
>about 7000 table, some of which are similarly corrupted.
>
>Server: Msg 7965, Level 16, State 2, Line 1
>Table corrupt: Could not check object ID 263984317, index
>ID 0 due to invalid allocation (IAM) page(s).
>Server: Msg 8968, Level 16, State 1, Line 1
>Table Corrupt: IAM page (1:955241) (object ID 263984317,
>index ID 0) is out of the range of this database.
>DBCC results for 'MyTable'.
>There are 0 rows in 0 pages for object 'MyTable'.
>CHECKTABLE found 0 allocation errors and 2 consistency
>errors in table 'MyTable' (object ID 263984317).
>repair_allow_data_loss is the minimum repair level for the
>errors found by DBCC CHECKTABLE (MyDB.dbo.MyTable ).
>
>
>>-----Original Message-----
>>Have you tried running dbcc checktable?
>>You may also want to see if the following applies in your
>>situation:
>>FIX: Error Message 5180 May Occur When You Retrieve Text
>or
>>Image Data (Q276043)
>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>US;Q276043
>>
>>-Sue
>>
>>On Thu, 27 Jun 2002 15:07:18 -0700, "Mike"
><ltear@yahoo.com>
>>wrote:
>>
>>>I am getting the following msg when I run a select Query
>>>on one of my newly created tables:
>>>
>>>Server: Msg 5180, Level 22, State 1, Line 1
>>>Could not open FCB for invalid file ID 0 in
>>>database 'MyDB'. Table or database may be corrupted.
>>>
>>>Connection Broken
>>>
>>>I am running this in the query analyzer. It allows me to
>>>query many other tables. I am also able to see entry for
>>>this table in the SYSOBjects master table. I just can't
> do

>>>any query on this particular table. Any suggestions?
>>
>>.
>>

Report this post to a moderator

repair worked. Thanks sue. found a dbcc checkdb. I'll try
to find other corrupted tables. Thanks again for prompt
response.

>-----Original Message-----
>I ran the dbcc checktable. It came back with the
following
>error msg. Is there any way to repair this? Also is there
>a query to run and fix all the currpted tables? I have
>about 7000 table, some of which are similarly corrupted.
>
>Server: Msg 7965, Level 16, State 2, Line 1
>Table corrupt: Could not check object ID 263984317, index
>ID 0 due to invalid allocation (IAM) page(s).
>Server: Msg 8968, Level 16, State 1, Line 1
>Table Corrupt: IAM page (1:955241) (object ID 263984317,
>index ID 0) is out of the range of this database.
>DBCC results for 'MyTable'.
>There are 0 rows in 0 pages for object 'MyTable'.
>CHECKTABLE found 0 allocation errors and 2 consistency
>errors in table 'MyTable' (object ID 263984317).
>repair_allow_data_loss is the minimum repair level for
the
>errors found by DBCC CHECKTABLE (MyDB.dbo.MyTable ).
>
>
>>-----Original Message-----
>>Have you tried running dbcc checktable?
>>You may also want to see if the following applies in your
>>situation:
>>FIX: Error Message 5180 May Occur When You Retrieve Text
>or
>>Image Data (Q276043)
>>http://support.microsoft.com/default.aspx?scid=kb;EN-
>US;Q276043
>>
>>-Sue
>>
>>On Thu, 27 Jun 2002 15:07:18 -0700, "Mike"
><ltear@yahoo.com>
>>wrote:
>>
>>>I am getting the following msg when I run a select
Query

>>>on one of my newly created tables:
>>>
>>>Server: Msg 5180, Level 22, State 1, Line 1
>>>Could not open FCB for invalid file ID 0 in
>>>database 'MyDB'. Table or database may be corrupted.
>>>
>>>Connection Broken
>>>
>>>I am running this in the query analyzer. It allows me
to[co
lor=darkred]
>>>query many other tables. I am also able to see entry[/color]
for[c
olor=darkred]
>>>this table in the SYSOBjects master table. I just can't
> do

>>>any query on this particular table. Any suggestions?
>>
>>.
>>
>.
>[/color]

Report this post to a moderator

Please don't blindly run repair without trying to work out why the
corruption happened in the first place. Your hardware may be bad in which
case you will most likely see errors/lose data again.

As the output from CHECKDB stated, you had to run REPAIR_ALLOW_DATA_LOSS to
get this error fixed - depending on what it decided to do to fix the error,
it may have deleted some of your data (as the option and BOL state clearly).

You should always use backups and call PSS when dealing with CHECK* errors.
Using repair should be your very, very last resort.

Paul.
--
Paul Randal
Security & DBCC, SQL Server Storage Engine
Microsoft, Redmond, WA

This posting is provided "AS IS" with no warranties, and confers no rights.
"mike" <ltear@yahoo.com> wrote in message
news:1153501c21ec9$90bb9ef0$37
ef2ecf@TKMSFTNGXA13...
> repair worked. Thanks sue. found a dbcc checkdb. I'll try
> to find other corrupted tables. Thanks again for prompt
> response.
>
> >-----Original Message-----
> >I ran the dbcc checktable. It came back with the
> following
> >error msg. Is there any way to repair this? Also is there
> >a query to run and fix all the currpted tables? I have
> >about 7000 table, some of which are similarly corrupted.
> >
> >Server: Msg 7965, Level 16, State 2, Line 1
> >Table corrupt: Could not check object ID 263984317, index
> >ID 0 due to invalid allocation (IAM) page(s).
> >Server: Msg 8968, Level 16, State 1, Line 1
> >Table Corrupt: IAM page (1:955241) (object ID 263984317,
> >index ID 0) is out of the range of this database.
> >DBCC results for 'MyTable'.
> >There are 0 rows in 0 pages for object 'MyTable'.
> >CHECKTABLE found 0 allocation errors and 2 consistency
> >errors in table 'MyTable' (object ID 263984317).
> >repair_allow_data_loss is the minimum repair level for
> the
> >errors found by DBCC CHECKTABLE (MyDB.dbo.MyTable ).
> >
> >
> >>-----Original Message-----
> >>Have you tried running dbcc checktable?
> >>You may also want to see if the following applies in your
> >>situation:
> >>FIX: Error Message 5180 May Occur When You Retrieve Text
> >or
> >>Image Data (Q276043)
> >>http://support.microsoft.com/default.aspx?scid=kb;EN-
> >US;Q276043
> >>
> >>-Sue
> >>
> >>On Thu, 27 Jun 2002 15:07:18 -0700, "Mike"
> ><ltear@yahoo.com>
> >>wrote:
> >>
> >>>I am getting the following msg when I run a select
> Query
> >>>on one of my newly created tables:
> >>>
> >>>Server: Msg 5180, Level 22, State 1, Line 1
> >>>Could not open FCB for invalid file ID 0 in
> >>>database 'MyDB'. Table or database may be corrupted.
> >>>
> >>>Connection Broken
> >>>
> >>>I am running this in the query analyzer. It allows me
> to

> >>>query many other tables. I am also able to see entry
> for
> >>>this table in the SYSOBjects master table. I just can't
> >do
> >>>any query on this particular table. Any suggestions?
> >>
> >>.
> >>
> >.
> >

Report this post to a moderator