Windows

Question

How to Restore SQL Database from MDF file

Hello, Can anyone tell how to restore SQL server database if in case my MDF file got corrupted?
Thread display: Collapse - | Expand +

All Answers

Collapse -

You can Try this Solution to Restore SQL database

by andrewmanson1994 In reply to How to Restore SQL Databa ...

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/

Collapse -

How to Restore SQL Database from MDF file

by anniebr In reply to How to Restore SQL Databa ...

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

Collapse -

Best Method to Restore SQL Database from MDF File

by aakshitr1 In reply to How to Restore SQL Databa ...

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/

Collapse -

SQL DATABASE

by danielbora In reply to How to Restore SQL Databa ...

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.

Related Discussions

Related Forums