Error attaching Database

[magdyk]

hi

i used to use SQL server 7.0 and now i uninstall it and installed sql server 2000
trying to restore my settings :

whenever i try to attach the (mdf,ldf) file i got a massage :

ERROR 90033: The LSN (3580:418:1)Passed to log scan in database 'Database Name' is invalid

PS: i tried to delete the log file and attach only the mdf
but still the same error

please anyone have any idea why this happen or a clue or can direct me to right way please do


thank u

 

[tlbroadbent]

Do you have a backup of the SQL 7 database? If so, restore it to SQL 2000.

Is it possible that another LDF file of the same name exists in a different direcory and SQL Server has found that file?

I know it is a little late to say this but you should have just upgraded from SQL 7 to SQL 2000. It is almost painless to do so.

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.