I updated some content on the Server and cannot remember what. That is why I need the 'most recent' database from the Server back locally to my hard drive.
I usually perform a one time backup of that particular data base and take the backup as a place to work on new ideas. Depending on the version you are using (I am using FM Server 13). The databases are located in \\FMServer\Data\Backups. If you want to work with the live database (not preferred), you can take the database offline (Close it) and then copy the actual file from the server ( \\FMServer\Data\Databases.
Unhost (close) the file in the server admin console, go to the live file location on the server, copy the live file to your local drive and rehost (open) the file in the server admin console if needed. Alternative is to take a copy from backups.
If you're allowed to close the database temporarily...
In Admin Console under the "folder icon" there is a menu option "download database" active if the database is closed.
This will download a zipped copy of the database. Handy if the server is on a remote location and no other remote access is available.
This is the correct approach, and the best way to get the latest version (newer than the latest backup) and avoid any data corruption that might be caused by copying an open database file. More specifically:
A little late to the party. The technique I use gets you the latest file, and doesn't require you to close the file / kick out other users.
1. Create a "schedule" which performs a one-time backup, on cue, designed for the occasion. (Don't schedule it)
1. Run that script when you need copies your file(s).
2. Head to your backups folder and grab the files it just made, copy the file(s).
If you want to get fancy, you can create a PSOS setup, which
1. Runs that dedicated backup script.
2. Uses AppleScript / Shell scripts and/or BaseElements free plugin, to grab a copy of the resulting backup files into a container in the hosted file.
3. At which point you can download that file back out of that container field, from within your open current Remote session, meaning: you'll never need to log into the server at all once that's initially set up. Just press a button and receive a nice copy where ever you are.
Retrieving data ...