I am attempting to export a large database and import it to another PC over the Internet.
Sometimes my Internet connection fails resulting in a database export error, causing me to have to restart the export from the beginning.
Is it possible to resume the export from point where connection failed?
I am using Microsoft SQL Server 2008 R2.
Best Answer
If you have remote access to the server you are transfering I suggest you make a full back up of the database put it in a FTP or torrent (last option not very safe but easier if you don't know how to build a FTP server). Then when the file is transfered to the other server, you restore the backup. This option will save you the trouble with the internet since the transfer to files will be local and FTP or torrent transfers can be paused/resumed if case of connection failed.