When working with clients on fixing their corrupt SQL Server databases we run into some common beliefs about corruption that are not quite true, such as:
A full backup and restore of a corrupt database may help fix the corruption.
This is FALSE. If the database is not so corrupt that backups are failing, the full back up a database, the corruption is backed up also.
Rebooting the SQL Server may help with the corruption.
Also FALSE. Once the file is corrupt a reboot will not help. It may make things worse, for instance rebooting a corrupt database make end up leaving it off line, coming up in SUSPECT mode, or in a never ending Recovery Pending state.
If I just ignore the corruption it may go away or fix itself.
Very UNLIKELY. If you have a regular process that truncates the table with the corruption, then it will go away… Otherwise, very unlikely.
Please give us a call with the experience that Stedman Solutions, LLC has on repairing corrupt database we can help. Check out what some of our customer have to say at our Raving Fans page. Here is what one of our clients had to say after I helped with fixing their corrupt database.
We were in a bind, our clients are a manufacturing facility with 1000+ workers heavily reliant on their ERP system to run their operations. Their products are highly sensitive and require tracking each transaction for compliance purposes so this basically means manufacturing stops if the ERP stops…
And we had a major SQL DB failure. Almost 2 full days of production was lost, high cost, high pressure and high stress.
The hardware was not optimal, which didn’t help for time constraints and we were facing DBCC failures that just simply were not documented (or at least Google had no results).
We scoured the web for hints and tricks to help solve this issue and came across stevestedman.com and submitted a request for consultation, not knowing what to expect.
Steve and Derrick were fantastic, they were able to pinpoint the issue within a very short timeframe and helps us get back up and running.
Their expertise and specialist knowledge in this area of database corruption is by far the best I have ever seen.
A big KUDOS to you both and a big THANK YOU for fast and quick response.
Adam , DTS , Thailand
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!