-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.

closed as too broad by hot2use, mustaccio, kevinsky, Marcello Miorelli, Josh Darnell Aug 9 at 18:06

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

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

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