SQL data base copy to remote site

Question

SQL data base copy to remote site

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.

we are using SQL on primary.

Best Regards,

Imran

Answer 1

Are you using compression when you back up the file? That could reduce the size of the file.

Depending on what you want to achieve, there are a couple of more alternatives:

• Only ship a full backup once a week, and differential backups the rest of the week.
• Do log shipping, and copy all your transaction-log backups to the remote site.
• Set up Transactional Replication for a continuous copying.

All these methods come with their pros and cons, and which is the best for you depends on your requirements.

Answer 2

Hi @IMRAN，

Here is a same thread which has list several ways to do that.

You may kindly take a reference there.

How can I backup a remote SQL Server database to a local drive

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.