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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!