How to get database in new created SSMS sql server developer edition but I don't have back up of database but mdf file and ldf file are available.

  • 1
    How do you have the same data on the C drive? Do you mean you have the mdf and ldf files that did not get deleted when you uninstalled developer edition? Commented Aug 8, 2019 at 13:23
  • yes ldf and mdf files are still there I've uninstalled express edition and installed developer edition Commented Aug 8, 2019 at 13:25
  • 1
    So re-install express edition, attach the database files take your back up and move forward. You could try attaching the files to developer edition, but they may not work. Commented Aug 8, 2019 at 13:31
  • ok but how could can I get back data again Commented Aug 8, 2019 at 13:32

2 Answers 2


If you have the mdf file, you have your data. Re-install the SQL express edition, attach the database file take a backup and restore it to your developer edition, see Restore database according to editions if you have issues with the restore.

If you don't have the mdf file and you don't have a backup, it is gone, start over.

When you installed developer edition, if you created a database with the same name, and put the mdf and ldf files in the same place as the old SQL express edition, then you overwrote the mdf files and your data is gone.


thank you for your answer but I solved It out by using this link https://support.resellerclub.com/helpdesk/index.php?/Knowledgebase/Article/View/260/5/steps-to-attach-mdf-and-ldf-files-of-mssql-databases-to-convert-it-to-bak-format

Not the answer you're looking for? Browse other questions tagged or ask your own question.