I have two computers running sql server, sqlserver01 and sqlserver01. On sqlserver01 I backup the database locally to C:SQLBackupbackupfile.bak (db size: 150GB) then I copy and paste the *.bak file to sqlserver02 via the network. It finishes copying but when I try to restore it on sqlserver02 it fails. I have used tools like Eseutil from exchange but no luck. It seems like the bak file corrupts on the transfer.
What is the best way to copy over a 150GB *.bak file to another server then restore the *.bak file in a timely manner?
October 27, 2008 5:52 PM
June 24, 2009 5:34 PM