Skip to main content
Jamf Nation, hosted by Jamf, is a knowledgeable community of Apple-focused admins and Jamf users. Join us in person at the ninth annual Jamf Nation User Conference (JNUC) this November for three days of learning, laughter and IT love.

Backing Up the Database Using Jamf Pro Server Tools

Overview

You can use Jamf Pro Server Tools to create backups of the Jamf Pro database or schedule automated database backups.

Note: The time it takes to create a backup depends on the size of the database.

Versions Affected

Procedures

Creating a Database Backup

  1. Open Jamf Pro Server Tools.
  2. Click Database Connection in the sidebar.
  3. Configure the settings to match your database configuration, and then click Test Connection.
    • If successful, the message "Successfully Connected" appears, continue with Step 4 below.
    • If the connection is not successful, an error message will appear.
  4. Click Backup and Restore in the sidebar.
  5. Click Save Backup Now.
  6. Choose a location to save the backup and click Open.

Jamf Pro Server Tools saves the backup as a .sql.gz file.

Scheduling Database Backups

You can schedule database backups to occur on an ongoing basis. You can also automate the deletion of scheduled backup files that are older than a specified number of days.

  1. Open Jamf Pro Server Tools.
  2. Click Scheduled Backups in the sidebar.
  3. Select the Enable scheduled backups checkbox.
  4. Choose the hour and the days that you want backups to occur.
  5. (Optional) To automatically delete old backups, enter the number of backups that you want to keep in the Backups limit field. All older backup files will be deleted when the scheduled backups run. To retain all backups, enter "0".
  6. To save the backups in a custom location, click Browse and select a different location. Note: It is recommended that you store the backups on a separate drive.

Stopping Scheduled Database Backups

  1. Open Jamf Pro Server Tools.
  2. Click Scheduled Backups.
  3. Deselect the Enable scheduled backups checkbox.

Jamf Pro Server Tools immediately stops creating scheduled backups.

Additional Information

For related information, see the following Knowledge Base articles:

Like Comment
Order by:
SOLVED Posted: by mhegge

After upgrading to JAMF Pro Server 10.9, performing a manual database backup via the Server Tools is now giving a dialog box to enter a "configuration password".

Please advise as to what this is.

Like
SOLVED Posted: by drhoten

Hello @mhegge, this is the same issue you encountered at the command line when it was prompting you for the encryption key.

We've changed how we are handling encrypting the configuration file in v2.0.0 of the Jamf Pro Server Tools, and would recommend downloading and using that version since it no longer requires an encryption key.

You can read about the changes and steps needed for upgrading in the changelog.

Like
SOLVED Posted: by m.entholzner

Is there any information on how to create a fully automated DB backup on Windows Servers?
When using Jamf Pro Server Tools, the created task scheduler job is only run as the user that created that job and only when logged in. When changing the task to be whether a user is logged in or not, this will only work for the user that created the task, but not for another user, eg. a technical account.

Like
SOLVED Posted: by isradame

@m.entholzner According to Jamf support, the server tools do not support this feature yet. I am in the same situation. Where you able to find a solution?

Like
SOLVED Posted: by m.entholzner

@isradame not really a solution, but a workaround: create the backup via server tools => change the task scheduler job to always run => don't forget to change the stored password of the task scheduler job when changing your own account password ;) I know... far from ideal...

Like
SOLVED Posted: by isradame

@m.entholzner Thanks, I give it a try.

Like