database attach error 9003

[cyrunner]

have a database that went through a crash, actually the windows 2000 server actually hard crashed brought it back up but cannot get one of the databases to attach have tried all the standard ways to get it back and donot have a current backup. I think the database is dammaged but really need to get the data out anyone have an Idea on what to do the error is "" Error:9003: The LSN(37372:128:1) passed to log scan in database 'topsdata' is invalid"" any Ideas would be great and if not that is there a way to get into the database to get the info outeven if it is damaged ???

 

[tlbroadbent]

Have you tried attaching just the MDF file using sp_attach_single_file_db? If the error is only in the LOG then this should allow you to get most of the data, if not all of it. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[cyrunner]

yes I get I think an 1816 error with that one

 

[MaffewW]

re 1816 error - Is the version of SQL Server you are trying to attach to set up exactly the same as the one which your mdf file from?