SQL Server Database Recovery

When (Soft) Logical problems occur SQL server database recovery is usually attempted using a repair utility. In many cases these utilities can create bigger problems that can have disastrous effects. A PC that is not accessible can be bothersome, however an inaccessible company database is often a bigger problem.

Soft (logical) data loss symptoms

• Trouble rebooting
• Boot drive file system problems
• Server storage systems registry configuration lost or overwritten
• Accidental deletion of data
• Accidental reformatting of partitions
• Accidental refiguration of RAID drives
• Accidental replacement of hard drive

Sometimes whether the damage is physical or logical is unclear. Related symptoms can sometimes cause you to choose the wrong fix for the problem.

Soft (logical) or physically related symptoms
Server reboots but cannot access attached storage

• Failed or prematurely aborted restore
• Applications are unable to run or load data
• Extreme degradation of application performance
• Folders previously full of files may suddenly appear empty
• Inaccessible drives or partitions
• Corrupted data

Data Recovery Strategy
Making an improper assumption can lead to a disastrous outcome. Therefore it is important to remain calm in any situation and to have a good data recovery strategy available should you need one.

Backing up frequently is a crucial factor in SQL server database recovery. It can determine the type of recovery you will have. Still data can be recovered using other methods that can only be obtained by a data recovery specialist.