Keeping an up to date copy of a SQL Server database on another server
Just to clarify what I mean by having an an update to date copy we don't mind if the database is only updated or synchronized once a day.


Depending on the database size, I would use backup with compression and restore. You can easily automate this process.

Just take full backup with compression once every night, upload it to FTP (probably secure) and have a process on your end to download it and restore the database (overwriting the previous copy).

There are other methods like using SSIS - if you want selected tables only or using BCP OUT and BCP IN - provided you have same schema on your side.

Dont get into the hassle of implementing replication as making schema changes is a big headache + you have to generate snapshot and depending on the size of your database and network, it will have a performance impact on the source server.