Time Machine for database server backup

Discussion in 'Mac OS X Server, Xserve, and Networking' started by naiosx, Sep 12, 2016.

  1. naiosx macrumors newbie

    Joined:
    Sep 12, 2016
    #1
    I have a Mac Mini running FileMaker Server and I need a daily backup of the databases that include around 100.000 pdf files that take up to 12GB of space. I would like to keep the 10 latest backups of the whole database.

    FileMaker Server takes care of the full database backup and in order to keep a reasonable backup file size it uses 'hard links', a storage strategy where multiple directory entries refer to a single file, this means that not all the files need to be copied in each database backup instance, saving time and storage space.

    I would like a solution to copy this folder out into a Synology NAS. I need this to work unattended, I mean without the need to log into the server and launch any application.

    So far I tried an application called GoodSync that should be able to keep the server and the NAS folders synchronized but it doesn't work well and GoodSync developer support has not been helpful at all. I have the impression that the amount of files is the problem. Moreover a solution like this doesn't take advantage of the 'hard links' technique, so the backups are very slow and take a lot of storage space.

    I wonder if Time Machine would work as a solution but I have a couple of questions:
    • Can Time Machine work unattended? I mean launch and work from the computer startup, prior to logging in.
    • Does Time Machine keep the backed up files with the 'hard links' technique
    If Time Machine is not a good solution which one would you use for such a backup?

    Thank you!
     
  2. bernuli, Sep 12, 2016
    Last edited: Sep 12, 2016

    bernuli macrumors 6502

    Joined:
    Oct 10, 2011
    #2
    Time Machine's main goal is to have 1 complete backup of all your files current within an hour. The Time Machine System Pref Pane says it will hold "Hourly backups for past 24 hours. Daily backups for past month. Weekly backups for all previous months." If you have enough free space on the backup drive, this should hold true. If you run out of room, it will delete older backups to make room. I have Time Machine history going back over a year, no problem.

    Time Machine also uses hard links, which gives you a "complete" directory tree in each backup.

    I would think it would run in the background without logging in, but would have to test that out to be sure.
     
  3. AppleNewton, Sep 13, 2016
    Last edited: Sep 13, 2016

    AppleNewton macrumors 68000

    AppleNewton

    Joined:
    Apr 3, 2007
    Location:
    1 Finite Place
    #3
  4. Les Kern macrumors 68040

    Les Kern

    Joined:
    Apr 26, 2002
    Location:
    Alabama
    #4
    Carbon Copy Cloner has "SafetyNet", which keeps multiple copies quite nicely. While I did use Time Machine in my backup strategy, I depended more on CCC and it never failed me. It can also auto-run on an hourly basis.
     

    Attached Files:

Share This Page