How to take BackUp database From One server to another server on daily basis?
Hi,
we need to take backup from alpha to dev environment on daily basis by automatic. Anyone please help?
Comments
You can run a script that back-up all your CACHE.DAT files from alpha to your dev server.
Hello Subramaniyan,
If you can have a downtime for the DB, than you could write a script that dismount the DB, FTP it to another server and mount it again. This of course depends on the DB size and your network speed.
If a downtime is not possible, I would recommend doing a "hot backup" then copy (or FTP) it to another server and restore it. Another option is to use "external backup" with using a "freeze" & "Thaw" to ensure data integrity.
Further information:
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…
From the documentation: "The best strategies for backing up databases are external backup and online backup." External backup involves external scripts (examples are included in the documentation, but do not show actually taking the backup, as that is done by 3rd party technology). This is generally the best way to take backups. Online backups can be configured and run from within Caché. All the various backup strategies, and details about how to use them, are available here:
https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GCDI_…
Looking solution via programatically should take backup and restore from one server to another server. without using any third party.
You can use also a Storage Based replication method.
If your environment support it, you can:
- Freeze instance
- Replicate data
- Thaw instance
If replica time is short enough this could be a very usefull method.
If you have enough free space and you use Linux LVM, you can also use the LVM Snapshot.