Administering databases
 
Administering databases
Note  The following information is for server administrators and group administrators.
The Activity > Databases tab lists the databases hosted by FileMaker Server that you are allowed to manage.
If you are logged in as the server administrator, the Activity > Databases tab lists all hosted databases.
If you are a group administrator, the Activity > Databases tab lists the hosted databases in your administrator group folder.
The database files are grouped in the default Databases folder, the additional database folder, and any subfolders. To view the databases in a folder, click the arrow.
When you select a folder for a group, folders that are not associated with an administrator group are indicated by the following folder icon in the Select Folder dialog box:
Icon indicating folders that are not associated with administrator group
Folders that are associated with an administrator group are indicated by the following group folder icon:
Icon indicating folders that are associated with administrator group
FileMaker Server displays the number of databases in a folder after the folder name. The parent folder or subfolder of an existing group folder cannot be selected as a group folder.
About hosted databases
When FileMaker Server starts, it automatically opens, or hosts, all files in the FileMaker Server Databases folder and the optional additional database folder as well as files in subfolders one level down. See Hosting databases.
Viewing database details
You can view a list of hosted databases by using the Activity > Databases tab. The default Databases folder is displayed. If you don’t see the database filenames, click the arrow next to Databases to display any files in the folder and additional database folders.
For each database, you can view the status, the clients currently connected to the database, any FileMaker WebDirect connections, any FileMaker Pro or FileMaker Go connections, and the extended privileges enabled by FileMaker Pro. To view details for clients currently connected to the database, select the database name, then view the Details for section. This section shows the connected computer’s name, account name that was logged in, type, and IP address.
Managing hosted database
To manage hosted databases, including opening or closing them, select one or more databases, click Activity Databases tab Actions menu, then choose one of the following:
 
Choose
To
Open
Open selected databases with Status: Closed or Checking. See Opening hosted files.
Open All
Open all databases listed on the Activity > Databases tab with Status: Closed or Checking. See Opening hosted files.
Close
Close selected databases with Status: Normal, Paused, Opening, or Checking. See Closing hosted files.
Close All
Close all databases listed on the Activity > Databases tab with Status: Normal or Paused. See Closing hosted files.
Verify
Verify selected databases with Status: Normal. See Verifying hosted files.
Verify All
Verify all databases listed on the Activity > Databases tab with Status: Normal. See Verifying hosted files.
Download Database
Download databases listed on the Activity > Databases tab with Status: Closed. Selecting this option opens a dialog to save database files from the FileMaker Server database folder to your local system. See Downloading hosted files.
Clear the Encryption Keys
Remove the encryption password for the selected databases on the Activity > Databases tab. See Clearing the database encryption key.
Clear All the Encryption Keys
Remove all encryption passwords for all hosted databases on the Activity > Databases tab. See Clearing the database encryption key.
To start or stop a database, click Pause/Resume menu for Activity Databases tab, then choose one of the following:
 
Choose
To
Pause
Pause selected databases with Status: Normal. See Pausing hosted files.
Pause All
Pause all databases listed on the Activity > Databases tab with Status: Normal. See Pausing hosted files.
Resume
Resume selected databases with Status: Paused. See Resuming hosted files.
Resume All
Resume all databases listed on the Activity > Databases tab with Status: Paused. See Resuming hosted files.
To send messages to clients, click Activity Databases tab Actions menu, then choose one of the following:
 
Choose
To
Send Message
Send message to the selected clients. See Sending messages to clients of a hosted database.
Send Message to All Clients
Send message to all clients. See Sending messages to clients of a hosted database.
To delete selected databases with Status: Closed or to delete empty subfolders, click Trash/Remove menu for Activity Databases tab, and choose Remove. See Removing hosted files.
Notes
If you are a group administrator, your server administrator must configure your administrator group to allow you to manage the databases in your group folder. For more information, contact your server administrator.
To resize the width of a column, select the column heading border and drag it horizontally.
To put the columns in a different order, click a column heading, drag it, and drop it at the desired location.
Related topics 
Hosting databases
Database Server security settings
Scheduling database backups