Wednesday, November 11, 2009

Data Retrieval post Read/Write Error Message

Physical disk problems can be a result of various factors, such as, bad sectors on your hard drive, disk drive failure, or controller damage. A read/write error message pops up whenever your storage media gets physically damaged. This error message is primarily raised when you want to open a database file and MS SQL Server is unable to read the specified disk location. Furthermore, read/write error message disk problems leave your database in unmountable state making the records saved in it inaccessible. To overcome the hazards created by the error message, the best way is to restore the data from an updated backup. However, if the backup fails to restore the data due to its corruption or damage, then you will need to use advanced SQL Server Recovery services to recover your data.

As a practical instance, you experience the below read/write error message while attempting to access your database:

“%s: operating system error %d (%s) encountered”

Records stored in your database file become inaccessible after the above error message appears. Furthermore, the above error message repeatedly occurs each time you attempt to access the database records.


The root cause for the occurrence of the above is the physical disk problem caused due to bad sectors, human errors, hard disk controller damage, and many more similar reasons.


To comprehensively troubleshoot the above error message and access the database file, you will need to identify the damaged device by selecting the row from “sysaltfiles”, which contains same disk name mentioned in the error message:

USE master
SELECT name, filename
FROM master..sysaltfiles
The output of the above query displays the name of physical name of your hard disk.

Self-examine your hard disk and correct the problems. While the problem may solve at your end, the probability of database getting further corrupted always high. To ensure any further damage, it is advisable to opt for advanced SQL Repair services. These SQL Recovery services are provided by data recovery organizations and are performed by highly talented data recovery experts.

No comments:

Post a Comment