SQLTeam.com | Weblogs | Forums

Help recovering SQL database from .mdf file!

Hello guys,

My HDD crashed and I managed to recover .mdf and .ldf file of mysql database (created with sql 2005). Now, when I try to attach the .mdf file, in SQL Server Management Studio Express, I'm getting the following error:
TITLE: Microsoft SQL Server Management Studio Express

Failed to retrieve data for this request.


An exception occurred while executing a Transact-SQL statement or batch.

E:\CONTAS_LEU(2).mdf is not a primary database file. (Microsoft SQL Server, Error: 5171)



If anyone can help me, I uploaded the .mdf and.ldf files at wetransfer, I can provide the link if necessary.

Thank you in advance !

Is there another mdf file you are missing,seeing this one is contas_leu(2)

Nope, I recovered the files several times, using different softwares, that's why I renamed the files, but every .mdf has its own .ldf