SQL Server Table Backup 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 &amp; copy the .mdf &amp; .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 &amp; 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 &amp; 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 &amp; data in those tables.
I would run DBCC CheckDB and see what corruption you have in the database.  It sounds like it is disk corruption.  If that is the case you will likely have to restore from backup.

After you restore from backup you can compare the two tables in question.

You can also try BCP'ing the bad table out but if it is a i/o disk error it will likely die if the corruption is in the heap.