-2

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? – James Jenkins Aug 8 '19 at 13:23
  • yes ldf and mdf files are still there I've uninstalled express edition and installed developer edition – Uddyan Semwal Aug 8 '19 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. – James Jenkins Aug 8 '19 at 13:31
  • ok but how could can I get back data again – Uddyan Semwal Aug 8 '19 at 13:32
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.

| improve this answer | |
-2

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

| improve this answer | |

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