Saturday, February 25, 2012

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 attach.
see
http://www.nigelrivett.net/RecoverCorruptDatabase.html
Which should allow you to retrieve data.
>> I have not a latest backup available
Ummm...
"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 database
> 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 and
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 you
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 database
> available in the database menu of enterprise manager.
> Only data files are available
> Please help...
>

No comments:

Post a Comment