I always try to divide my HD into several hard drives
Hard drive 1: OS
Hard drive 2: Live databases
Hard drive 3: Backups
Hard drive 4: File stored in your databases
OS dont need much more then it´s installed space
Live databases should have at least twice the size of the databases to store the temporary databases FileMaker works with
Backups should have enough space to save more then what you need to save
Files is up to how much files you store
I do a Verify backup every night that writes over it self next night
I save a Clone every night and saves one for each day of the week
I save backups every 1-4 hour depending on how much people work in the database that will be overwritten next day
I then have a backup batch script that moves my backups to another disc outside the computer every night in good time after the Verify back is finished
Agree with Johan. I have a client with a similar MacPro. Databases total size about 4 GB. Busy op's with four locations. We do 15 minute backups to 2 external SSDs and hourly to the internal drive. No reports of drag or lag.
Thanks Stephen! do you know what model external SSD's they're using? I'm actually considering revising my original plan to stay with the 256GB internal drive and backup to 2 externals: https://eshop.macsales.com/item/Other%20World%20Computing/ENVPROU3S480/#owctabs
Drive 1: Progressive and Daily
Drive 2: Hourly and a 1x retention daily backup that gets copied to a NAS
Cheaper and spreads the backups to more drives, gets some I/O off the internal drive too.
Nothing special - seems they were about $300 CDN with cases. We also have a spare onsite.
This is my go-to resource before shopping for SSD:
I love and shop from OWC myself but you might also consider the Samsung EVO or PRO 850 series, which has held top spot for effective speed for quite some time.
Actually I think I have Samsung Pro in the current Mac mini (500GB)....but I'm going to be moving to a 2013 Mac Pro and it doesn't have room for internal SSD's aside from the primary flash storage. So I need a fast SSD in a fast external enclosure. But thanks, that site looks very helpful anyway.
Oh, sorry, i glossed over that detail in your post.