Please Help.Attach Db Errror

I try to attach a database and the following error occurs:
Server: Msg 644, Level 21, State 5, Line 1
Could not find the index entry for RID '16a5eed57f3000300' in index page
(1:29375), index ID 8, database 'mat'.
26 transactions rolled forward in database 'mat' (10).
I have not a latest backup available and the commands that refer to the
database such as "dbcc checkdb" do not help because i have not the database
available in the database menu of enterprise manager.
Only data files are available
Please help...Sounds like your database file is corrupt - you should never rely on an atta
ch.
see
http://www.nigelrivett.net/RecoverCorruptDatabase.html
Which should allow you to retrieve data.

Ummm...
"koletsis theo" wrote:
[vbcol=seagreen]
> I try to attach a database and the following error occurs:
> Server: Msg 644, Level 21, State 5, Line 1
> Could not find the index entry for RID '16a5eed57f3000300' in index page
> (1:29375), index ID 8, database 'mat'.
> 26 transactions rolled forward in database 'mat' (10).
> I have not a latest backup available and the commands that refer to the
> database such as "dbcc checkdb" do not help because i have not the databas
e
> available in the database menu of enterprise manager.
> Only data files are available
> Please help...
>|||I know this is not what you want to hear but I've been telling many, over an
d
over again, that the Backups, especially the Transaction Log backups, are
worth gold: they are more important that the online file precisely because
the database files can become corrupt.
I believe you have been forwarded the link on how to do a database recovery.
You should know that that error message is telling you that the page links
for the index pages have been corrupted. Moreover, because it is telling yo
u
the corruption is on a ROW ID, in all likelihood, the table only had a heap
defined, no clustered index.
Too no-nos. Always have a clustered index defined per table and
consistently run a DBCC CHECKDB against the databases, especially BEFORE you
detach them.
Sincerely,
Anthony Thomas
"koletsis theo" wrote:

> I try to attach a database and the following error occurs:
> Server: Msg 644, Level 21, State 5, Line 1
> Could not find the index entry for RID '16a5eed57f3000300' in index page
> (1:29375), index ID 8, database 'mat'.
> 26 transactions rolled forward in database 'mat' (10).
> I have not a latest backup available and the commands that refer to the
> database such as "dbcc checkdb" do not help because i have not the databas
e
> available in the database menu of enterprise manager.
> Only data files are available
> Please help...
>