Question

How to Restore SQL Database from MDF file

By jacksonandrew321 ·
Hello, Can anyone tell how to restore SQL server database if in case my MDF file got corrupted?
2 total posts (Page 1 of 1)  
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

Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums