A friend of mine has run into this problem on SQL Server 2008, please suggest a solution:
He came to know that auto backup scheduled on server were not taking place since last couple of days, when he tried manual backup of our database it gave following error:
System.Data.SqlClient.SQLError: Read "D:\DB\data.mdf" failed: 1 (Incorrect function.) (Microsft.SqlServer.Smo)
To safeguard our data he thought of rebooting the server in safe mode & copy the
.ldf files manually to a safer location but it gave an error after completing 80% of process (MS DoS invalid ...) which looked as if hard disk has some issue & it's not able to read the files from specific location.
He thought of copying the data table by table after creating a fresh database from DB script, during the process one of our developer by mistake dropped two important tables & he has not used
BEGIN TRANSACTION option also
Now he is looking forward for an expert advise if we have some recovery tool to recover those tables & data in those tables.