SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 3rd Party Recovery Tool - Real World Experience
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dotinsight
Starting Member

Brazil
1 Posts

Posted - 11/26/2013 :  08:06:54  Show Profile  Reply with Quote
Hi Everyone,

I'm looking to buy one or more recovery tool software, but it's very difficulty to find real world experiences on the internet.
Most of the 'tips' are from the manufacturers, advertising on forums as fake users/specialists.
The rest are just resulted from some googling and grabbing the first results links.

Thats's not what I'm looking for.

I want you (fellows, experts, MVPs, MCM), to share your personal real world experiencies with low level 3rd party recovery software, to be used on those situatons where everything else was tried and failed (including emergency mode, DBCC CHECKDB/CHECKTABLE REPAIR_ALLOW_DATA_LOSS, and so on).

DBCC is a very limited tool and when we didn't have any alternative options left, something recovered / partial recovery may be better than nothing.

There are many situations where one of the last rows of a critical system table (like sysrscols) gets corrupted in a large database.
So most of your database could be saved.

Other times, the size of the database files, for some odd reason are different on the metadata and on the disk, so SQL Server continues to read the file after the end of the file and aborts the connection.

This is something that could be fixed (the metadata information) and a good tool, should report any orphan allocation on metadata, beyond that point, giving us the option to accept that kind os data loss and fix it !

More than that, its very likely that the information on the page header of the actual data page is intact, so an incorret metadata about allocation could be corrected, even in that chaotic situation.

But I didn't found a tool with this kind of simple logic, but precise/detailed error reporting.

Most of them just prints how many rows were successfully read from each table with no reports, on what was wrong, what was fixed, what was lost, and so on (like DBCC actually does on many situations).

This kind of report can make us confident and able to agree an acceptable level of loss with the user or the client.

Bad experiences with some marketed tools are very useful too.
If we don't know what to buy, information on what TO DO NOT Buy is better than nothing.

Links to articles about unsupported system tables fixing/editing, using Dedicated Administration Connection, allowing updates on system tables,... and so on, are also very welcome.

Please no discussion or warnings. I'm aware about the risks, but as I told you before, I'm looking for solutions to exceptional situations where everything else was tried.

I'm sure it will help many of us.
No advertising, please !

rodyroon
Starting Member

6 Posts

Posted - 12/06/2013 :  05:31:26  Show Profile  Reply with Quote
Hello,

If you are interested to buy a third party SQL Recovery Software, then I would also like to refer you a perfect software named as Kernel for SQL Recovery Tool. You can try to use this software along with a free trial from here unspammed

hope above information help you to solve your problem.
Go to Top of Page

Houssine
Starting Member

USA
4 Posts

Posted - 02/11/2014 :  07:48:51  Show Profile  Reply with Quote
quote:
Originally posted by dotinsight

Hi Everyone,

I'm looking to buy one or more recovery tool software, but it's very difficulty to find real world experiences on the internet.
Most of the 'tips' are from the manufacturers, advertising on forums as fake users/specialists.
The rest are just resulted from some googling and grabbing the first results links.

That's not what I'm looking for.



Dear dotinsight,
If you are looking to buy some recovery tools, you can check SysInfoTools products. I do always recommend SysInfoTools products when it is about data recovery and mail management. It offers all its software with free demo version.

Thanks.
Go to Top of Page

prett
Posting Yak Master

USA
181 Posts

Posted - 03/12/2014 :  01:54:56  Show Profile  Visit prett's Homepage  Reply with Quote
Hi Dotinsight,

You can find personal experience of Sean Gallardy with Stellar Phoenix SQL recovery software from bellow link:
http://www.seangallardy.com/2013/05/software-review-stellar-phoenix-sql-recovery-v4-1/

Sean gallardy has got several awards: Microsoft certified contributor, Microsoft certified IT professional, Microsoft certified master & more from Microsoft.

I hope that it will help you in choosing the best recovery tools.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000