Stellar Knowledge Base

How to Recover Deleted Records using Stellar SQL Repair?

Author : Creative Team Updated on March 3, 2017

Stellar Phoenix SQL Database Repair is an advanced application that repairs all the corrupt or damaged SQL databases without modifying the original content format. This application includes various powerful modules that not only restore your inaccessible database, but also to recover deleted records and table from the corrupted SQL database.

Here are the steps to recover deleted records in MS SQL database (MDF) file.

Run Stellar Phoenix SQL Database Repair
From the main interface, click ‘Select Database icon’ and select a database file that you want to repair from the File Menu or from the list of MS SQL Database files found.
Now, to recover deleted records select 'Include Deleted Records' check box before start repairing process and click ‘Repair’ button to start the process.
 

Main Interface of Stellar SQL repair

 
After successful repair, a message appears to confirm the successful completion of the process and you will be prompted to preview window. The left pane displays list of all the items in a tree like structure. You can click the listed items to check the preview.
 

 
 
 

 

 

 

The listed database also includes all the deleted tables & records without any modification in the name of original tables.


Now, to save the repaired database, select ‘Save’ button from File menu or click ‘Save’ button available on the Quick Access Toolbar and select the MSSQL radio button. 

 
 
 
 
 
 
A new window appears, where you will get two saving options ‘New Database’ & ‘Live Database’ you can select one option according to your requirement.
 
 
Now, you need to enter Server/Instance Name and connect with the server, either select a destination (New Database) to save the repaired MDF file or choose an existing database (Live Database) to save the repaired file.
 

 

2 User Comments

 

Ahmed Bafadel
March 20, 2016 08:05 pm

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

Amit Pandey
March 21, 2016 11:39 am

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 Phoenix 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

 

User Comments

 



 

 

Stellar Phoenix & Stellar Data Recovery are Registered Trademarks of Stellar Information Technology Pvt. Ltd.
© Copyright 2017 Stellar Information Technology Pvt. Ltd. All Trademarks Acknowledged.