Hi!

I am getting the follow error message when trying rebuild an index or
run DBCC Checkdb.

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to
fetch logical page (1:53888) in database 'db1' belongs to object
'tbl1', not to object 'tbl2'.

Any Idea?
Thank you,
T.

On May 20, 3:20 pm, tolcis <nytolly...@gmail.com> wrote:
> Hi!
>
> I am getting the follow error message when trying rebuild an index or
> run DBCC Checkdb.
>
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to
> fetch logical page (1:53888) in database 'db1' belongs to object
> 'tbl1', not to object 'tbl2'.
>
> Any Idea?
> Thank you,
> T.

Forgot to mention it is SQL 2000 SP4.

Ouch. You have a database corruption issue. First, make a backup and do
not delete any old backups. Run a DBCC CHECKDB and see what it says. You
may just have an index page mis-allocated. If so, you can run DBCC CHECKDB
('BadDatabaseName', REPAIR_REBUILD. )

I suggest you read teh BOL topic on DBCC CHECKDB before you try actually
running the command with any of its options.

Also, check your Windows system event logs to see if there are any
indications of hardware problems with your disks. That is probably where
the corruption initiall occurred.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"tolcis" <nytollydba@gmail.com> wrote in message
news:635d48c0-e167-480f-beae-2e3f287fb807@w4g2000prd.googlegroups.com...
> Hi!
>
> I am getting the follow error message when trying rebuild an index or
> run DBCC Checkdb.
>
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to
> fetch logical page (1:53888) in database 'db1' belongs to object
> 'tbl1', not to object 'tbl2'.
>
> Any Idea?
> Thank you,
> T.