THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Damian Widera

Stellar Phoenix SQL Database Repair - first look / review

Today I was able to play with the Stellar Phoenix SQL Database Repair a little bit

What is Stellar Phoenix SQL Database Repair

According to the website the tool is able to fight with these problems:

·         Repairs corrupt MDF and NDF file of SQL Server database

·         Recovers tables, triggers, indexes, keys, constraints, rules, and defaults

·         Restores SQL Server ROW-compressed and PAGE-compressed data

·         Supports MS SQL Server 2014, 2012, 2008 and all lower versions

 

I took a simple database data file that already has a corruption. If you tried to attach the file to the server you would see the error:

The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only.

This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.

 

As I had only the data file I was trying to attach the database using the sp_attach_single_file_db system stored procedure first.

I opened the tool and the first information is as follow:

That makes sense as it is hard to perform any operations on database files if those are under the control of the database engine. The only way is to take the data file or files away from the SQL Server.

The next step is to select the data files. There are two possible ways to do so as you can see on the picture below:

-        You can point in to the database

-        You can search for it

 

I chose with the first option and clicked the “Repair” button. The next and last question is about the database version. That step is necessary as metadata of SQL Server databases changed over the time. I picked SQL Server 2014 and clicked “OK”.

 

Now the application started to work out and after a while I was informed that it is possible to repair my database. The applicaton presented the short report of all actions it had taken. 

It is possible to take a look at the database, examine all objects and even to see the data:

 

At this point it is possible to repair and save the database (means also to attach) to the given instance of SQL Server.

 And the magic happened J The database is up and running!

 

Conclusion

I really like the very simple and very intuitive interface. It is that simple that you even don’t have to remember all the fancy options as I imagine such program might have. The application just repairs the database in an automatic way J.

Information:

The Product Webpage: http://www.stellarinfo.com/sql-recovery.

Published Monday, August 24, 2015 4:32 AM by Damian

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Greg said:

I heard about this tool but did not use yet. It’s looking useful for SQL repair & Interface is also looking cool. Thanks Damian

August 24, 2015 1:32 AM
 

Tina said:

Nice review Damian.

August 27, 2015 1:47 AM
 

Damian said:

Jason - for sure it is - there are a lot of tools that could help us survive corruptions!.

I will check that one you mentioned, too

August 27, 2015 8:20 AM
 

Damian said:

Greg - Thanks :)

August 27, 2015 8:21 AM
 

Damian said:

Tina - Thanks!

August 27, 2015 8:21 AM
 

Robin said:

I tried Stellar Phoenix SQL Database Repair tool and it protects me from a very big blunder.

August 27, 2015 11:26 PM
 

Mark said:

Andrew, Stellar Phoenix SQL database repair also supports recovery of deleted records from the database.

August 31, 2015 6:52 AM
 

Sonika Rawat said:

Great informational article you can share, but i can share an another S. Rawat's Blog for best data recovery or email management tool and tips.

September 28, 2015 4:59 AM
 

dwayne said:

if you come across corruption of MS SQL database files and if it becomes inaccessible to you then you must look out for some third party repair tool that could repair and restore all your deleted and damaged files.............one such tool that i would suggest you is SQL DATABASE REPAIR TOOL.......... Since i am a user i know how beneficial and effective it is...

Therefore, before the conditions become critical, repair SQL MDF files using SQL Repair Tool and restore back your crucial tables, views, indexes and other important data stored in it.

http://sqlmdf.filerepairtool.net/

October 30, 2015 1:14 AM
 

Liza said:

I am not sure about the other tools but Stellar Phoenix SQL Database repair is an awesome tool. It repaired my SQL database successfully :)

November 19, 2015 1:53 AM
 

Damian said:

dwayne It will always be a corruption when a tool is unusable. In that case yuo have to try to fix it manually - if you can :)

November 19, 2015 3:40 AM
 

Damian said:

Liza, thanks for the comment

November 19, 2015 3:41 AM
 

Daniela said:

You did a great job Damian.

December 2, 2015 1:05 AM
 

edbmails said:

Thanks for the information. Really useful ..

For more information, visit: https://www.edbmails.com/pages/download-edb-to-pst-edb-to-office-365-edb-to-live-exchange-migrator.html

March 12, 2018 4:24 AM

Leave a Comment

(required) 
(required) 
Submit
Privacy Statement