Depends on the type of data you are managing in your database. The issue that arises is that you could have a copy of the record on your hosted site that is modified by a user in one manner and then a copy of the same record might be modified by a different user and in a different way on the emergency back up copy. A third user working on a third copy of your file might then edit this same record in yet another way. Then you have to have some way to detect the changes and merge all of them back into the same file.
With records that are seldom updated after they are created such as invoices, this may not be a major issue. With other types of data, merging the edits back into a single set of records could be very complicated and messy.
I figured that would be the case. these records are modified daily and it can cause problems, perhaps a better solution is to leave different files per location.
The backup copies that are created by the server are stored to a local folder and i manually copy them to an external drive that goes in a safe in a remore location. copying the file over a vpn takes to long since its several GB per location and we prefer not to allow an employee access to the server, can you think of a way i can back this to a remote location (my location) automatically, im not sure if FMS 11 has this capability and I cant think of a faster way of doing this.
I tried hosting a copy of the file on my server and created a script that i run to update existig records in found set and adding others as new, this is not really any faster than cppying the entire file though.
FileMaker cannot backup a file to a remote location--even another drive on the same network. It can backup the file while it is open and hosted by server so a common backup strategy is to back up the database to a directory on the local drive and then use a third party backup utility or system script to copy the file from the back up folder to the remote volume. We do that here with VBScript file run from Windows Task Manager about 30 minutes after the Server Schedule backs up the file to the local directory.