2 Replies Latest reply on Jul 31, 2014 4:15 PM by Malcolm

    Real World Back up Solutions/Advice

    laser

      Hi -

       

      We have recently developed a nice FIlemaker soluion for our research group. Now that we are ready to deploy it, I realized I did not have a thoughtful backup solution.

       

      We are running FileMaker Pro 12 on a Mac and have stored the database file(s) in labeled folders.

       

      People will periodically be entering data throughout the day and some times there can be days between entries.

       

      We have access to off-site "cloud" storage which I beleive I will back up to on a daily basis.

       

      But I am curious about more frequent backups throughout the day.

       

      Is Time Machine (Mac back up) a good solution for making incremental backups throughout the day? Or is there something else we should consider?

       

      Indeed, the data is precious so I am also wondering about the possibility of accidentally backing up corrupted data. How is this avoided?

       

      How often and how many of the backups need to be looked at to ensure that they useable and accurate?

       

      Ideally, our data would be accesible and useable for 20 years.

       

      I am hoping for for any real world, simple and robust solutions/advice you may have.

       

      Thank you very much in advance.

        • 1. Re: Real World Back up Solutions/Advice
          DavidJondreau

          I'm assuming you're using a single client of FileMaker Pro? The gold standard is to use FileMaker Server and its built-in back up scheduling. Preserving the data for 20 years? Interesting constraints...

           

          If it's mostly the data you're concerned about, I'd say a scripted export routine that pushes out a collection of .csv files. I wouldn't trust a .fmp12 file to be usable in 20 years. But a text file would be.

           

          You can script regular FileMaker back up as well.

           

          Save both to a Dropbox folder and a local folder and that should be enough.

           

          How those scripts are triggered depends on your workflow. For example, you can have them run whenever someone opens the file, assuming that file is closed every night, but if you leave the file open for two weeks...then that won't really work.

          • 2. Re: Real World Back up Solutions/Advice
            Malcolm

            We are running FileMaker Pro 12 on a Mac and have stored the database file(s) in labeled folders.

             

            I am curious about more frequent backups throughout the day.

             

            Is Time Machine (Mac back up)  a good solution for making incremental backups throughout the day? Or is there something else we should consider?

             

            You are skating on thin ice. FMPro client is not really a robust multi-user server and Time Machine is not really the best option for your backups.

             

            I suggest that you exclude the FMPro folders from your TimeMachine backup preferences. Use Calendar and Applescripts instead.

             

            Use Calendar to set up a scheduled task which runs every hour. A calendar schedule can call an automator script or an applescript. The applescript then calls a filemaker pro script which does a Save a Copy into your Cloud backup folder. The advantage of this is that the task scheduling is handled by FMP. If it’s busy when the applescript runs, the applescript has to wait.

             

            For long term storage of your data I agree with David Jondreau, export the data from each table as a csv. Obviously this sort of archival storage only needs to take place at significant intervals, daily? weekly? at project close?

             

            Malcolm