Home >> Software Detail Page

 

Stellar Phoenix SQL Recovery – Tool to repair Corrupt MDF file

 

Stellar Phoenix SQL Recovery is a highly advanced utility to help MS SQL database administrators in repairing their corrupt databases and restore them back. With the software, you can easily repair the corrupt or severely damaged MS SQL Server database file (.mdf & .ndf) and recover all database objects, including Tables, Views, Triggers, Stored Procedures, User Defined Functions, Indexes, and Rules etc.

 

The software is able to deal with any instance of SQL Server problem and recovers maximum possible data from the damaged .mdf & .ndf files. In case, the SQL Server database has been corrupted beyond the scope of recovery, the software provides an innovative option to recover queries of objects in a text file. Apart from this, even though this SQL Server database repair utility is designed with many powerful database recovery techniques, it implies completely non-destructive approach and recovers your precious data in their original format. Listed below are some of the prominent features of the software:

 

Key Features – Stellar Phoenix SQL Recovery

  • Repairs corrupt .mdf files and recovers inaccessible database components
  • Provides option to find all .mdf files in the system, in case you do not know the location
  • Facilitates recovery of Tables, Triggers, and Views
  • Facilitates recovery of Collations, and Default Constraints
  • Facilitates recovery of Stored Procedure, Synonyms, and Functions
  • Facilitates recovery of Primary Keys, Foreign Keys, Unique Keys, and Identity
  • Facilitates recovery of Indexes (Clustered, Non - Clustered indexes)
  • Facilitates recovery of Check constraints, User Defined Data Types, and Null / Not null
  • Facilitates recovery of Predefined defaults, default values, and Rules
  • Provides preview of recoverable objects before actual recovery
  • Supports recovery of user defined schema-bound sequence objects in SQL Server 2014
  • Supports recovery of ROW Compressed data
  • Supports recovery of PAGE Compressed data
  • Supports Standard Compression Scheme for Unicode (SCSU) in SQL Server 2008 R2
  • Recovers Column Row GUID COL Property
  • Recovers Sp_assextended Property
  • Retrieves unrecoverable queries, views, stored procedures etc. in a text file
  • Creates a new SQL database having all the recovered database items
  • Supports recovery of large sized SQL Server .ndf files in all versions
  • Supports recovery of XML data types
  • Supports recovery of XML indexes
  • Supports recovery of SQL Server 2008 filestream data types
  • Supports recovery of SQL Server 2008 sparse columns
  • Supports recovery of SQL Server 2008 columns set property
  • Supports recovery of separate log report after scanning database
  • Shows Tables in a sorted format
  • Provides the total row count information in each recovered table
  • Generates a sorted log report of the entire repair & recovery process
  • Supports MS SQL Server 2016, 2014, 2008 R2, 2008, 2008*64, 2008 Express, 2005, 2005*64, Express, 2000, 2000*64, 7.0 and mixed formats
  • Designed to work on Windows 10, Windows 8, Windows 7, Vista, XP, Server 2008, and Server 2003

 

Reasons behind SQL Database Corruption

It is due to improper exit of the database application, virus/malware infection, sudden system shut down, file system corruption or conflicts with recently installed hardware/software, the SQL Server database gets corrupt. Stellar SQL Recovery software has been developed keeping all these conditions in view and it successfully repairs SQL Server database and brings back all database components in their original format.

 

Stellar SQL Recovery recovers database objects from all instances SQL Server corruption..

 

While accessing a corrupt SQL Server database, it flashes various error messages on the screen. There are many such error messages, some of which are listed below:

 

Stellar SQL Recovery can be Helpful in the following error scenarios-

  • Error -"Server can’t find the requested database table"
  • Error - Table error: Extent P_ID object ID O_ID, index ID I_ID is beyond the range of this database.
  • Error - “Table error: Object ID 2171059069, index ID 1. The high key value on page (1:77) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page
  • Error - "The process could not execute ‘sp_replcmds’ on server."
  • Error -"You must be member of the system admin fixed server role to complete this operation"
  • Error - “Table error: Object ID 2171059069, index ID 1. The high key value on page (1:77) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page
  • Error -"A floating point exception occurred in the user process. Current transaction is canceled."
  • Error - “Page P_ID, slot S_ID in Object O_ID Index I_ID Column COLUMN_NAME value COLUMN_VALUE is out of range for data type "DATATYPE". Update column to a legal value”

 

Note:  You can find many such common SQL database errors and their detail solution in our ' How to Repair SQL Errors' Section.

 

The software is available in a Free Demo version, with which you can crosscheck the credibility of the software for free. The demo version shows preview of all recoverable database objects and if you are satisfied, you can purchase the full version to recover them.

 

 

downloadbuy now

*Free Download allows previewing SQL database objects in the main interface. To save the recovered database, you need to register the product.

 

What's New in Stellar SQL Recovery 7.0?

Recently, Stellar has launched a new version of its SQL Server Recovery software with lots many useful features. The newly added features are listed below:

 

  • Complete support for MS SQL Server 2016
  • Recovers deleted records
  • Saves repaired database in multiple options
  • Recovers schema-bound sequence objects introduced in SQL Server 2014
  • Recovers MS SQL tables with ROW compression
  • Recovers MS SQL tables with PAGE compression
  • Recovers data in their original languages as it supports Standard Compression Scheme for Unicode(SCSU) in SQL Server 2008 R2
  • Recovers Sp_assextended Property
  • Recovers Column Row GUID COL Property

 

How to Repair Corrupt SQL Database using Stellar Phoenix SQL Recovery:

Stellar Phoenix SQL recovery software comes with highly interactive graphical user interfaces and facilitates the recovery process in few easy steps. Below screen-shots will give you a clear picture of the entire repair and recovery process:

 

Select Corrupt Database & Scan

Click 'Select Database' and select the corrupt SQL Server database file (.mdf). If you do not know the exact location of the .mdf file, then click the 'Search Database' button to find all .mdf files in the system. Choose the required corrupt .mdf file and click 'Scan'.

 

Preview Recoverable Objects

On successful completion of the scanning process, the software provides preview of all recoverable database objects in a tree-like structure. Select any object to view its content.

 

Recover Database

Check-mark all or only the required database objects to be recovered. Click ‘Start Repair’ icon and provide the ‘Server Name/Instance Name’. Give the location, at which you want to save the repaired SQL Server database and click ‘OK’ to continue.

 

The repaired SQL Server database along with all its objects will get stored at the specified location.

 

downloadbuy now

*Free Download allows previewing SQL database objects in the main interface. To save the recovered database, you need to register the product.