SQL Server Database Recovery

Electronic failure, head crashes and stretched/crumpled media are examples of the types of physical problems that can threaten SQL server database recovery. Approximately seventy percent of all data loss is due to physical problems.

Some Symptoms may include

• Sudden server crash while operating or starting up the computer
• Ticking or grinding noises
• Single hard drive failure
• Multiple drive failure
• RAID controller alarm flashing
• RAID controller failure rendering drives inaccessible
• Intermittent drive failure resulting in configuration corruption
• Visible fire or water damage

SQL Server database Recovery Tips

Never power up the system when obvious or suspected physical damage is evident. Doing so can worsen the situation by making data recovery harder to achieve.

Do not attempt to remove a damaged or unspoiled tape from a drive unless you have the specialized knowledge and equipment to do so. Professional data recovery experts have the right tools and environment to ensure successful data recovery.

Be very careful when considering applying any of the do-it-yourself software solutions on the market. There is no software in the world that can fix problems when physical damage has occurred.

Temporary Fix
Another computer/server should be configured to temporarily replace the problem unit. Backups should be restored onto this unit to get the company up and running again until a data recovery specialist has the problem fixed.