I am in need of some advice. We recently had a database go down and become corrupted. When I went to restore I receive the following error (Title Bar: ODBC SQLSTATE42000, Message:Internal Consistency Error, contact technical assistance...... I did have this happen once a few months back but on the third or fourth attempt all went well. Not so in this case. Using the different "Verify" commands SQL Server states my backup is there and complete.
We did find 2 bad disks (Raid 5) on our SAN box that keeps the backups. These will be replaced tomorrow. However I did move the backup to another location only to receive the error message.
This is a fairly critical database and I am in need of any help that can be offered. (Please keep in mind while answering this question that I am not a dba)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!