How do you create a second Back up which is an incremental Backup to an offsite FTP Server?
Thanks for reading.
You can do different kind of backups with your FileMaker Pro do different places, but not to a FTP Server. For that you need to do a ordinary backup first and then trigger a batch script from FileMaker Server Schedule to move the files for your. If you are not familiar with batch script, just make your computer to the move to your FTP but have plenty of time for the backup to finish before you start to move so that backup is not working when you are trying to move files
Dear Johan, Thanks for the input. I'm doing that saving it with FMS 15 and then an other program backing it up to the FTP Server, the result is that it does it every time new and not incremental and just building up massively. Any suggestion other then how I do it?
You can have FM make incremental backups to a folder.
And than use some other software to sync that to a FTP server.
Or use a scheduled script for this with a plugin offering FTP upload, e.g. MBS Plugin.
FMS stores things to look like they are incremental, but only so that we can take a backup if we have problem. If you get all folders in side your Incremental backup you are going to get size bigger and bigger.
I would take one nightly full backup that also do verification on your databases and move to a FTP. Rest of the backups that you do during the day could be incremental.
How do you set up on FMS incremental backups?
Here is everything you need to know about backups
Steven_FL wrote: How do you set up on FMS incremental backups?
Careful with your expectations though: each backup set in the FMS incremental backups folder is a full set, not a differential with the previous set. So if you are looking at this for your source to the FTP backup it is not going to be any different than FTPing an ordinary backup set.
There is no way you can do true incremental backups; that is because of FM's file format.
Thanks Wim, so doing a progressive backup and the backing up that whole progressive backup folder to the FTP server will not work. Is that right?
It will work but I wouldn't do it. Progressive backups start their interval when the database engine starts. So while you can control the interval you have no control over when the backup happens.
Say that you start the db engine at 1:25pm and have progressives running every 10 minutes then the next backup will happen at 1:35pm.
If you restart your server and the db engine starts at 3:07pm then the next progressive will happen at 3:17pm.
That makes it hard to have a separate process like the FTP pick up the backups without adversely affecting the running of the progressives.
You are much better off to base your FTPs of a true regular schedule that you know will always kick in at the same time. And the best approach is to do everything with OS scripting tools:
- run a backup from the fmsadmin CLI
- then trigger the FTP from the CLI
this way you will never have timing issues and the incomplete/invalid backups that can result from that.
Retrieving data ...