Rebooting the SpecVet Server

Overview

Occasionally, it may be necessary to reboot the server that runs SpecVet. This could be to install operating system updates, to remedy performance issues, to accommodate power outages, etc. It is important that the FileMaker Server platform be shut down properly to avoid data corruption issues as well to significantly improve the startup time when the server comes back up. This document is designed to show you how to properly shut down the FMS/SpecVet server.

An Uninterruptible Power Supply (UPS) is highly recommended for your SpecVet server. A minimum of 30 to 60 minutes of power is recommended. This will allow your IT staff or us adequate time to properly shutdown the server in the event of a power outage.

IMPORTANT - Your staff must notify us or your IT staff immediately if you lose power for more than a few minutes. Failure to notify IT negates the benefits of having the UPS.

How to Shut Down the SpecVet (FileMaker) Server

1. Log into the server.

Credentials can be obtained from SpecVet Technical Support.

2. Open a web browser.

Supported browsers are Safari, Internet Explorer, and Chrome.

Enter http://localhost:160001/admin-console into the address bar.

Admin Console Address

4. Login to the Admin Console

Use same credentials that you used to login to the server.

Admin Console Login

5. Lock out SV Client Connections

This step prevents clients from immediately logging back into the server after being disconnected.

  1. Click Database Server on the sidebar.
  2. Select the FileMaker Clients tab (if not selected).
  3. Check the box to Limit number of FIleMaker Pro client connections.
  4. Set the number of connections to zero (0).
  5. Click the Save button.
Lock out Clients

6. Disable Schedules

Disabling schedules will prevent automated FileMaker scheduled processes from interrupting or delaying the shut down.

  1. Select Schedules on the sidebar.
  2. Uncheck the box next to Allow enabled schedules to run.
Disable Schedules

7. Disconnect Clients

Clients must be disconnected to preserve file integrity.

  1. Select Activity on the sidebar.
  2. Select the Clients tab.
  3. Click the envelope icon on the right side of the window.
  4. Select Disconnect All Clients from the drop down menu.
Disconnect Clients

A new window named Disconnect All Clients will open.

  1. Enter a message that will be sent to the clients.
  2. Enter the Delay time (default is two minutes). The delay time allows users to finish working and exit the database before being disconnected.
  3. Click OK to start the process.
Disconnect Message

8. Wait for Clients to Disconnect

Once the disconnect process has begun, clients should begin dropping off the server. Disconnection progress can be monitored from the Activity menu of the Admin Console. The client list will get shorter as clients drop off.

Wait for Disconnect

Occasionally, you not be able to get all clients to disconnect. In this case:

  1. Wait a few minutes to allow them time to disconnect.
  2. Attempt the disconnection process again.
  3. If some clients are still connected, continue with the process below.

9. Run a Backup

Running a backup is always a good idea when shutting down the database server. It's essential in the case where not all clients are able to be disconnected.

  1. Select Schedules from the sidebar.
  2. Select a backup to run.
    • Backup schedules will show "Backup" in the Type column.
    • Backups are typically named by frequency eg Daily, Hourly, Weekly,
    • All of the backups save the same data, so the choice isn't critical.
  3. Click the calendar icon on the right side of the window.
  4. Select Run a Schedule Now.
Run Backup 1

Once the backup has started. The status for that backup will change to "Running." It's important to wait until the backup has completed before continuing.

NOTE: Depending upon the age of the SpecVet deployment and activity level of the clinic, the backup can take several minutes. Typical backup times range from 5 to 20 minutes.

Run Backup 2

10. Close all databases

Once all clients have been disconnected and the backup has completed, the database files can be closed. This is the critical step to prevent unnecessary delays in reopening the files after the server reboot.

  1. Select Activity from the sidebar.
  2. Select the Databases tab.
  3. Verify that all databases have zero (0) clients.
  4. Click the folder icon on the right side of the screen
  5. Select Close All from the dropdown menu.
Close Databases 1

After the Close All process has begun, the Status of the SpecVet database files will change from Normal to Closing, and finally to Closed.

Wait until all files are Closed before proceeding.

Close Databases 2

11. Unlock Client Connections

Now that the databases are closed, client connections can be reinstated. Clients won't be able to access the closed files, but performing this step now saves time after rebooting.

  1. Select Database Server on the sidebar.
  2. Select the FileMaker Clients tab.
  3. Uncheck the box to Limit number of FileMaker Pro client connections.
  4. Click Save.
Unclock clients

12. Re-Enable Schedules

Like unlocking the client connections, re-enabling the schedules will now will save time later.

  1. Select Schedules from the sidebar.
  2. Check the box for Allow enabled schedules to run.
Enable Schedules

13. Turn off the FileMaker Server in Admin Panel

The final step before rebooting is to turn of the FileMaker Server in the Admin Panel. This is essentially the same as turning off the service in Windows using the Services Control Panel.

  1. Select Status from the sidebar.
  2. Click the on/off button on the right hand side.
Stop Server 1

The Stop Database Server dialog window will open.

  1. Change the Delay Time to zero (0). This is not mandatory, but it will speed up the shut down.
  2. Click OK.
Stop Server 2

14. Reboot machine with OS

The databases have been shut down and it is now safe to shutdown or reboot the server operating system. Once the system restarts. FileMaker Server will automatically load and open the databases.

15. Reopen the FileMaker Admin Console and Verify that all databases are open and clients have access.

Reopen the Admin Console and login using steps 1 through 4 above.

Then,

  1. Select Activity from the sidebar.
  2. Select the Databases tab.
  3. Check that the statuses of all the SpecVet database files are normal.
  4. Verify that clients are connecting to the databases.
Verify Operation