Schedule Database to Open and Close
I've been looking into having FileMaker Server open and close a hosted database at certain times of the day. Is that even possible?
Not as far as I can tell. Why would you need to do this? (Maybe there's an alternative approach that does not require closing the file...)
We're find that if you leave a hosted file open more than 24 hours it starts to act flakey. We wanted to schedule a database to open and close at certains times of the time. Say for example, close at 10 PM and re-open at 8 AM.
Out of curiosity,
what OS is on the server?
What are you hosting? (DB for FileMaker clients, IWP hosting, Custom web publishing.....)
We have FileMaker Server 10 installed on two servers. We have a windows server 2003 server that just runs 24/7 with no issues. We only shut down/restart to apply windows system updates.
We have a server 2008 system that runs pretty solid, but periodically experiences the "deaf server" bug first identified with server 10. When this happens, we restart and all is well till the next time which could be the next day or it could run for weeks/months without going deaf. Access to the db from FileMaker clients is not affected. Only server schedules fail to run until we restart.
We're running FileMaker 11 Server on an X-Server running 10.6.8 Server. Server runs rock-solid, no crashes. Users authenticate off a Open Directory Server.
FMServer should run 'rocksolid' - although I don't use Open Directory, but our server runs 24/7 without db-close
For scripting 'close', shell scripts with the fmsadmin - commands could be the solution, scripts that run by the OS scheduler
Did you find a solution? I have the same request, but for a different reason. FM Server does not have the ability to backup to Dropbox, so I need to shut all the databases down, then backup the file to Dropbox, then re-open the databases. Files are hosted on a RAID drive and a separate backup drive, but we have no offsite storage. FM server schedules have no option for scheduled close and open (arg!!). I've seen suggestions for Shell commands, but that's way too technical for us!
No. Never found a solution. We're looking into scripting the database client to open and close the database.
Has anyone found a solution for this? It seems like with FM Server 13, under 'Schedules' in Admin Console, it should just be a matter of creating a FileMaker script that would close the selected database(s) and then a separate script that could be scheduled to open them again. Am I thinking too simplistically, or is that all that should be involved in doing that?
I would like to do this for a similar reason as Ted above. I want the databases to close during the evening so that I can use CarbonCopyCloner to clone our MacMini server drive. I am presuming that leaving FM Server running is fine, just that all databases should be closed at the time.
Any advice or recommendations would be appreciated.
Retrieving data ...