Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dotinsight
Starting Member
1 Post |
 Posted - 2013-11-26 : 08:06:54
|
| 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
7 Posts |
Posted - 2013-12-06 : 05:31:26
|
| 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 unspammedhope above information help you to solve your problem. |
 |
|
|
Houssine
Starting Member
15 Posts |
Posted - 2014-02-11 : 07:48:51
|
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. |
|
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2014-03-12 : 01:54:56
|
| 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. |
|
|
|
elliswhite
Starting Member
36 Posts |
Posted - 2014-05-05 : 00:36:41
|
| Here is top 10 recovery tool available: http://www.the-top-tens.com/lists/best-sql-recovery-software.asp[url][/url] |
|
|
|
|
|
|
|
|
3rd Party Recovery Tool - Real World Experience