Server Script - Close all Databases

[rivet]

Just ran into a nasty situation.

Without knowing it, a db file on our FMserver 9 corrupted, 10 days ago. Then yesterday the server needed to be restarted, and that is when we notice the db would not open.

We would like to add a check for this in the future and one way I was thinking was to schedule the server to close and open all files each night. That was if the file doesn't open we can catch it sooner.

I can see in the Admin console there is an option to run a system-level script.

- Has anyone does this on a Mac server?

- Preferred script would be close and open files.

[corn]

I've run shell scripts on a Mac server running FMS 9.

There is syntax to the FMS commands that can be found in the FMS admin guide. You will likely need to supply permissions to the commands within your script. You might also want to open the files one by one so you can better log which files are having problems and the error returned by FMS.

I haven't written a script that does exactly what you're asking so I don't have an example to share unfortunately.