TechRepublic|Forums|Windows Forum

Windows Forum

Question

  • Creator
    Topic
  • September 11, 2019 at 8:23 am #2145067

    How to Restore SQL Database from MDF file

    by jacksonandrew321 · about 5 years ago

    Tags: 

    Hello, Can anyone tell how to restore SQL server database if in case my MDF file got corrupted?

  • Creator
    Topic

You are posting a reply to: How to Restore SQL Database from MDF file

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

  • Author
    Replies
    • September 23, 2019 at 5:50 am #2422657

      You can Try this Solution to Restore SQL database

      by andrewmanson1994 · about 4 years, 12 months ago

      In reply to How to Restore SQL Database from MDF file

      Hi, I understand your situation. You have corrupted MDF file right? If you want to restore the SQL database then I found an informative article for you. This article explains the step by step guide to perform this task. For complete information, the user can refer to this: https://www.systoolsgroup.com/how-to/restore-sql-server-database-from-mdf-file/

    • October 1, 2019 at 10:52 am #2422598

      How to Restore SQL Database from MDF file

      by anniebr · about 4 years, 11 months ago

      In reply to How to Restore SQL Database from MDF file

      First Put the .mdf and .ldf file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ folder

      Then go to SQL software, Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box

      Click the “Add” button to open and Locate Database Files From C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\folder

      Click the “OK” button. SQL Server Management Studio loads the database from the.MDF file.

      If this method failed then you can also try Stellar Repair for MS SQL.
      To know more – https://www.stellarinfo.com/sql-recovery.php

    • January 8, 2021 at 5:38 am #2416632

      Best Method to Restore SQL Database from MDF File

      by aakshitr1 · about 3 years, 8 months ago

      In reply to How to Restore SQL Database from MDF file

      One can easily perform the task using Microsoft SQL Repair Tool. This tool will help you to restore the SQL database from the MDF file.

      Visit – https://www.mailconvertertools.com/microsoft-sql-repair-tool/

    • January 8, 2021 at 7:04 am #2416629

      SQL DATABASE

      by danielbora · about 3 years, 8 months ago

      In reply to How to Restore SQL Database from MDF file

      1. Open SSMS and go to “Object Explorer”.

      2. Right-click the database you need to restore and select “Attach”. Click the “Add” button when “Attach Database” Windows appears.

      3. Browse the location of MDF file and select it. Then, click “OK”. And SQL Server Management Studio will restore the database from the MDF file.

  • Author
    Replies
Viewing 3 reply threads