where is the database file once it's up in the server

[saralee]

Hi all, gonna ask a silly question: once I upload my database file in FM Server Advanced, how can I retrieve the file to my local disk again? Where is it stored in the server? I need to get the most current database file..

Thanks!

[fseipel]

If you launch the admin console it will show the location, under Configuration|Database Server|Default Folders, typically it is C:/Program Files/Filemaker/Filemaker Server/Data/Databases.

Note that you should close file before copying out (or run scheduled or on-demand backups, and copy out from the backup if database can't be closed).

[Vaughan]

Once the file is hosted it's best to leave the file alone. Only ever copy from the backup folder.

While the admin console is open, run the backup script, then copy from the backup folder.

[saralee]

Thank you both! Assume that I cannot close the file, so I need to run the backup script to backup. Where is this backup script? Thanks!

[fseipel]

You will probably want to go to the Schedules tab on the admin console and create a schedule to execute backups. Backup will proceed while database is open. You can 'run now' to execute schedule(s) immediately. Alternately you can run backups from the command line.

Backups will end up in C:/Program Files/FileMaker/FileMaker Server/Data/Backups/ unless you've changed backup path in admin console|Configuration|Database Server|Default Folders. Ideally the backups should be saved to a different volume, e.g. with a shell script run after the backup, so if server hard drive fails you still have a backup.