question

JamesBradle avatar image
JamesBradle asked

What is the best tool for corrupt SQL database repair and recovery

What is the best tool in terms of efficiency, cost and success rate for repairing and recoverying corrupt SQL 2005 database files? I need to purchase a tool for my Database Admins and I am searching for the best bet in the industry.
recoverytoolssql databaserepair
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mart avatar image
Mart answered
There are tools out there that allow you to restore specific parts of databases files e.g. [ http://www.apexsql.com/sql_tools_recover.aspx][1] Restoring from a backup is probably the best, most reliable and most tested method though. Your DBA's will/should be restoring the backups regularly to check they work so they'll already have a process to do this without needing to learn anything new. It's not just a case of restoring a database or a part of a database to 'fix' corrupted data though, they'll need to understand how corruption occurred in the first place (the error will help here) and how to fix that otherwise they'll likely be an ongoing fight to 'fix' corrupted data - take a look at Paul Randal's blogs on this, he's written many ([ http://www.sqlskills.com/blogs/paul/][2]) Hope this helps! [1]: http://www.apexsql.com/sql_tools_recover.aspx [2]: http://www.sqlskills.com/blogs/paul/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jason_clark03 avatar image
jason_clark03 answered
If you're looking for a way to repair a SQL Server database file (.mdf), then, you can use the SQL Database Recovery Software which has reliable features with easy GUI also the price is affordable and you can download the demo free of cost from here: [ http://www.sqlserverdatabaserecovery.org/][1] [1]: http://www.sqlserverdatabaserecovery.org/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DazyParker avatar image
DazyParker answered
Before using any 3rd party tool; you should use the automatic repair option of SQL Server database. These options are: **REPAIR_REBUILD:** This command is for the minor corruption. To apply this command, Set the database in single user mode. Use Database_name GO ALTER DATABASE Database_name SET SINGLE_USER GO DBCC CHECKDB(‘Database_name’,REPAIR_REBUILD) GO **REPAIR_ALLOW_DATA_LOSS:** When corruption is not recoverable by the simple repair rebuild option then, this option can be very helpful. As it is clear from the name, the corrupted data will be lost from the database. To use this option, use the following syntax: DBCC CHECKDB (‘Database_name’, REPAIR_ALLOW_DATA_LOSS) All these repair commands are able to fix database corruption issues. In case of badly corruption, user can use the third party tool like [Stellar Phoenix SQL database repair][1]. Stellar Phoenix SQL Database Repair is most recommended software by MVP’s for repairing corrupt database. It has several features: [1]: http://www.stellarinfo.com/sql-recovery.php - Able to repair .MDF and .NDF files. - Also supports latest SQL Server 2016 - database. Also worked on Windows 10. - Able to repair SQL database from suspect mode
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wilfred van Dijk avatar image
Wilfred van Dijk answered
2 things: Much more important: make sure you are *prepared* for corruption: run backups with the CHECKSUM option and do a regular DBCC CHECKDB check. Also, check the errorlog and define alerting. Do you know the RPO and RTO values, defined by your company? If you have critical values, maybe you have mirroring or AlwaysOn. In that case automatic page repair is also active. If there's corruption, don't panic! Restoring a database is not always necessary. If you' ve got a message about database corruption, have a look at the message. For example, if there's corruption in a nonclustered index this could be fixed by dropping and re-creating the index. Which is much faster and cheaper compared to a "professional" tool. So knowledge is also important. Don't get the idea that next->next->finish in a tool is your livesaver
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HyoThomas avatar image
HyoThomas Suspended answered
There are plenty of [Free Best SQL Database Repair and Recovery Softwar][1]e that repair the SQL server database. You need to choose only one of these software on the basics of cost, reliability, popularity, security and feature. But, before using external software for SQL repairing, I suggest you to use in-built utility for SQL repair. Only when the in-built utility fails to give satisfy results, then you need to use the above discussed SQL repair tool. [1]: http://www.myfilesrecovery.com/free-best-sql-database-repair-software/
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Very helpful SQL repair utility. Thanks..
0 Likes 0 ·
mahima11 avatar image
mahima11 answered
I would like to recommend SysInfotools SQL database recovery software to repair your corrupt MDB & NDF files with full accuracy. Also, This tool offers high accuracy recovery of SQL file objects like: tables, views, store procedure, programmability, triggers, default and functions with.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

daisysmith250 avatar image
daisysmith250 answered
One can also try another excellent 3rd party software, SQL Database Recovery. The software quickly repair data from corrupt MS SQL file of any version. During recovery process software dose not harm any data contained in the MDF & NDF files. For more information about the software, visit- [ http://www.sqldatabaserecovery.org/][1] [1]: http://www.sqldatabaserecovery.org/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.