472,122 Members | 1,518 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,122 software developers and data experts.

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

2
What is the best tool in terms of efficiency, cost and success rate for repairing and recovering 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.
Nov 17 '15 #1

✓ answered by RuneLassen

Be really sure that your db files are not compressed first. Right click on both the db files and the logs for all DBS (especially those that are system db's but basically any you want to use) go to properties then advanced and un tick the box that says compressed. Using certain OS cleaners will compress the files on your hard drive including db and log files. This causes them to behave as though they were corrupted.
If you have db's that you haven't backed up that are corrupted then try my suggestions as compressed db's will give you all sorts of errors. I dont want to sound pedantic but I would make sure I had good backup procedures and verbose logging rather than having a tool to recover corrupted databases. This sort of thing is last resort.
If you really need the program lot of tools available in Market. If you don't have the time and desire to search for, you can try a suitable tool SQL Server Recovery Toolbox which I usually use. This is my recommendation at your discretion. http://www.oemailrecovery.com/sql_recovery.html

4 1672
http://www.thetoptens.com/best-sql-recovery-software/

This site should give some options
Nov 18 '15 #2
Maybe this post will help you?
https://community.office365.com/en-us/f/172/t/266070
Nov 19 '15 #3
Be really sure that your db files are not compressed first. Right click on both the db files and the logs for all DBS (especially those that are system db's but basically any you want to use) go to properties then advanced and un tick the box that says compressed. Using certain OS cleaners will compress the files on your hard drive including db and log files. This causes them to behave as though they were corrupted.
If you have db's that you haven't backed up that are corrupted then try my suggestions as compressed db's will give you all sorts of errors. I dont want to sound pedantic but I would make sure I had good backup procedures and verbose logging rather than having a tool to recover corrupted databases. This sort of thing is last resort.
If you really need the program lot of tools available in Market. If you don't have the time and desire to search for, you can try a suitable tool SQL Server Recovery Toolbox which I usually use. This is my recommendation at your discretion. http://www.oemailrecovery.com/sql_recovery.html
Nov 19 '15 #4
fields
2
Thank you guys for your feedback and help. Sorry, that long time did not respond. This is because the issue was solved and I forgot to tell.) Thank you!
Nov 29 '15 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Steve | last post: by
3 posts views Thread by Tina | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.