Stellar Knowledge Base

How to Recover Deleted Records using Stellar SQL Repair?

 Modified on: December 22, 2021 |    39761 views

Stellar Repair for MS SQL is an advanced application that repairs corrupt SQL database (.mdf) file and recovers all the database objects, including deleted table records.

Steps to recover deleted records from corrupt MDF file using the software are as follows:

  • Download, install, and launch the SQL recovery tool.
  • Click 'Browse' to select the SQL database you want to repair. If you’re not aware of the database location, click the 'Find' button to locate the database.
  • To recover deleted records, select the 'Include Deleted Records' checkbox and then click ‘Repair.’

  • Choose an appropriate scan mode ‘Standard Scan’ or ‘Advanced Scan’ for scanning and repairing the corrupt database (MDF) file. Click ‘OK.’
  • A message appears confirming successful completion of the repair process. Click ‘OK’ to proceed.
  • A preview window opens containing a list of recoverable database items in the left pane. From these items, look for the table records marked as deleted. Click on any deleted records to view its contents in the right pane of the preview window.
  • To save the deleted records, click ‘Save’ from the ‘File’ menu.

  • Select ‘New Database,’ ‘Live Database,’ or ‘Other Formats’ as the saving options, and then click ‘Next.’

  • Enter Server/Instance Name and authentication mode to connect with the server. Choose default or new location to save the recovered deleted records and then click ‘Next.’

  • Choose an appropriate file saving mode and click ‘Save.’

  • You will get the ‘File saved successfully’ message on completion of the saving process.

Navigate to the location where you have saved the repaired database. Open the database and you can see deleted records in the database.

 

2 User Comments

What about if I install the software on normal PC not server ? How I can copy The SQL file to server ?

gravatar

Ahmed Bafadel

Hi Ahmed,

You can download & install the software on PC. Detach your mdf file from SQL server; copy to the PC. Now repair the detached file with Stellar SQL database repair software. Software will fix all the issues and provides option to save repaired database.

Now, you can attach the repaired file to the server.

Please let me know if you have any further queries.

Thanks
Amit Pandey

gravatar

Amit Pandey

 

User Comments

verfy04

 

 

Stellar Repair for MS SQL Stellar Repair for MS SQL is most recommended software by MSSQL Administrators. The Software fixes corrupt SQL database files and recovers inaccessible objects to save business data.

Learn More red arrow

 

Related Articles

 

WHY STELLAR® IS GLOBAL LEADER

Why Choose Stellar?

  • 0M+

    Customers

  • 0+

    Years of Excellence

  • 0+

    R&D Engineers

  • 0+

    Countries

  • 0+

    PARTNERS

  • 0+

    Awards Received