An advanced SQL Server database recovery software recommended by MVPs and database administrators worldwide to restore SQL database. It scans and repairs corrupt SQL Database (MDF & NDF) files. Also, it recovers all database components, including tables, triggers, indexes, keys, rules, stored procedures, etc.

Recovers SQL Database (.mdf and .ndf) files
Recovers deleted records from SQL Database
Supports SQL database recovery on both Windows and Linux systems.
Supports recovery of SQL 2019, 2017, 2016, 2014, 2012, 2008 & older versions.

When to Use Stellar Repair for MS SQL?

Is SQL Database in SUSPECT Mode?

When the primary filegroup of the database is suspected to be damaged by SQL server or if the transaction log file is missing or has turned corrupt, the database is marked as ‘Suspect’. Also, events such as SQL server crash in the middle of a transaction, abrupt database termination, lack of disk space etc. can bring the database in suspect mode. Consequently, database becomes inaccessible. Stellar SQL recovery tool helps to recover SQL database from suspect mode and restores SQL database to normal state (online).

Is SQL Server Log file (.LDF) Lost or Corrupted?

SQL administrators encounter errors due to damaged transaction log file (.ldf) in SQL server. These errors include database ‘file activation failure’, ‘SQL error 9004 or 9001’ (while attempting to attach a corrupted log file), 'Could not open new database [Your_DatabaseName]', etc. Stellar Repair for MS SQL uses advanced algorithms to repair corrupt MDF file and restore the database in its original form. Once the database is restored, you will get access to its transaction log file (.ldf).

What to do When DBCC CHECKDB Will Not Work?

Microsoft SQL Server provides in-built utility DBCC CHECKDB with multiple repair options to fix SQL database corruption and restore the db. However, the DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS involves data loss risk, while fixing consistency errors and corruption in SQL database. Also, the in-built utility may fail and return an error when dealing with severely corrupt SQL database files. Stellar Repair for MS SQL repairs all types of corruption in SQL database, maintaining data integrity.

Awarded by

SQL Server Central

The managed to extract data in almost all corruption cases. The tool is good value for money given its out of the box functionality.

MSSQLTips.com

For SQL Server DBAs, the Stellar Repair solution for SQL Server enables us to affordably recover a database or a subset of data when time is of the essence.

Key Features

MDF and NDF File Recovery

MDF (.mdf) is the primary data file containing database header and all the information of the database, whereas NDF (.ndf) is the user-defined secondary data file that also contains user data. SQL Server database corruption typically affects both MDF and NDF files, and thereby makes the database inconsistent and inaccessible. The SQL recovery tool helps perform database recovery in SQL Server by repairing corrupted MDF and NDF files.

Recovers SQL Database Objects

The SQL recovery tool recovers all the database objects, including Tables, Keys, Indexes, Views, Triggers, Stored Procedures, Rules, User Defined Functions, and more. In addition, the MS SQL database recovery tool supports recovery of XML indexes and data types, column set property, sparse columns, and file stream data types.

Recovers Deleted Records from SQL Database

The SQL data recovery utility also recovers deleted table records from corrupt SQL database. You can restore all your deleted records without affecting the existing table data and original hierarchy. It also allows saving the recovered data in a newly created table, below the original table. This helps in differentiating between recovered deleted records in the new table and original table.

SQL Database File Saving Options

The SQL Database recovery software allows to save the recovered SQL server database file in MDF and other file formats CSV, HTML, and XLS. Saving in other file formats is helpful since you don't need to install SQL Server on your system for opening the recovered file. Additionally, queries of severely corrupt objects that are not recovered can be kept in a separate text file.

More Awesome Features

Options to Scan and Recover SQL Database

The SQL data recovery tool provides two scan options to recover a SQL database (MDF) file. Select the Standard Scan mode for quick scanning of the .mdf file. Select Advanced Scan mode for deep scanning of the .mdf file.

Recovers ROW and PAGE compressed Data

SQL tables with PAGE and ROW compression can also be restored by using Stellar SQL database recovery software. It also supports Standard Compression Scheme for Unicode (SCSU) for SQL Server 2008 R2, and recovers all data in its original format.

Previews Recoverable Database Objects

The SQL Server recovery software scans corrupt database and displays a list of all recoverable items in a tree-like structure. The tables are listed in a sorted manner, which facilitates selecting any table to view its contents. The preview feature also helps verify if the recovered contents match the original data that was present in the database prior to corruption.

Selective Recovery of SQL Objects

The software helps perform selective database recovery in SQL Server, by allowing you to choose a specific or multiple database objects that you want to recover. The functionality allows selecting specific database objects that need to be recovered from the list, and saves them at a default or specific location.

Search Items & Reconnect Automatically

The SQL recovery tool provides 'Find Items' function to facilitate searching for intended items on the basis of specific criteria, such as 'Match whole word' or 'Match case'. Further the tool can automatically reconnect SQL server, when there is a disruption during the process of database recoveryin SQL Server. This ensures smooth running of recovery process.

Windows and SQL Server Authentication

The SQL database recovery software allows you to configure the SQL Server to use either Windows authentication or SQL Server authentication method to perform database recovery.

Saves the Scan Results Automatically

The software automatically saves the scan result of SQL Database MDF file during its recovery process. The result can be used to recover database file at a later stage. This is a useful feature, as you can resume file repair process without the need to scan the database MDF file again, thus, saving time.

Stellar Toolkit for MS SQL

Stellar Toolkit for MS SQL is a 3-in-1 specialized suite comprising tools to repair corrupt SQL files, extract SQL data from corrupt backup (.bak) file, and reset SQL Server Admin and user passwords. The toolkit supports SQL Server 2019, 2017, 2016, 2014, & older versions till 7.0.

Recovers SQL Database on Windows and Linux Systems

This MS SQL database recovery software supports recovery of MS SQL database on both Windows and Linux machines. The tool works with Windows 10, 8.1, 8, 7 OS. The tool is compatible with Ubuntu 16.04 (64-bit) / Ubuntu 18.04 (64-bit) / Ubuntu 19.10 (64-bit) / CentOS 7 (64 bit) / Red Hat Enterprise Linux 7 (64bit).

Restores Database in SQL Server 2019 and Beyond

The MS SQL MDF File Recovery tool helps recover data from corrupt or inaccessible MDF files of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008, 2008 R2 and older versions.

Technical Specifications

About Product

Version

9.0.0.5

Release Date

August, 2020

License

Multiple Users

Version Support

MS SQL server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, and earlier versions

Edition

Technician, Platinum, & Toolkit

End User License Agreement

EULA

Language Supported

English

System Requirements

Processor

Intel-compatible (x86, x64)

Operating System

Windows 10, 8.1, 8, 7 and Windows server 2012, 2008, 2003

Memory

4 GB minimum (8 GB recommended)

Hard Disk

250 MB for installation files

Quick Navigation;