SQL data base copy to remote site

Question

we are taking sql full backup on daily base and our data base size is 800 Gb above , what is the best way to copy SQL data backup to remote site server , right now im using ftp to copy my sql backup files but it taking long time because off the file size.

Answer 1

Hello,

Thank you for posting to the Microsoft Community Forum.

According to the description, I understand that your issue is related to SQL Server.

Since there are no engineers dedicated to SQL Server in this forum. In order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

Here is the link for Q&A forum.

Questions - Microsoft Q&A

Click the "Ask a Question" button in the upper right corner to post your question and select "SQL Server" tag and any other tags related to your products.

Have a nice day!

Best Regards,

Shujun

Answer 2

FTPing is probably the fastest transfer rate unless a better proprietary protocol exists. The only other way of expediting things is by using compression to lower the file size. Either in the exportation of the database or by using something like zip. However, compression may lead to an increased chance of file corruption. Comparing the checksums at both locations may be one way to verify a successful copy.

Another way to limit size is by modifying how often Level 0 and 1 backups occur depending on your needs.

Answer 3

Thank you Dear Shujun for your replay , i will do that.

Answer 4

Thank you for your replay dear Techfreak_