There is a big database on remote server. A read-only replicate is required on a local server. The data can only be transferred via FTP, etc. It's ok to replicate it once a day.
Logshipping is an option. However, it need to kill all the connections when doing restoring. What's the other options (pros/cons)?
Aucun commentaire:
Enregistrer un commentaire