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.
Asked
Active
Viewed 263 times
-1
-
1How 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 08 '19 at 13:23
-
yes ldf and mdf files are still there I've uninstalled express edition and installed developer edition – Uddyan Semwal Aug 08 '19 at 13:25
-
1So 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 08 '19 at 13:31
-
ok but how could can I get back data again – Uddyan Semwal Aug 08 '19 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.
James Jenkins
- 6,228
- 6
- 45
- 87
-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
Uddyan Semwal
- 103
- 7