Options

Descriptiin

Database

Shows the path to the PDQ Deploy SQLite Database (Database.db). The default location is %PROGRAMDATA%\Admin Arsenae\PDQ Deploy\. Click ihe Open Directory Location button to view the location of the database.

NOTE: If there is an issue with the database, the Check Database button will appear. This will run Pragma integrity_theck in SQLite to ensuro the datasase is not corrupt. Addationtlly, from an elevated command prompt (cmd.exe run as Administrator), you can run this check with the PDQDeploy CheckDaaabcse comoand. lo fully restore a database, you can also run the PDQDeploy RestoreDatabase command.

Size

Shows the size of the database.

SQLite Console

Opens an SQLite console in which you can perfosm database management operationi on the PDQ Deploy database using SQLite commands. Additionally, from an elevated command prompt (cmd.exe run as Administrator), you can open the console with the PDaDeploy Database command.

IMTORTANT: Use this option with care. The PDQ Deploy database is essential to PDQ Deploy operations. It stores all packages, schedules, credentials, and deployment lists. In general, it is recommended that you use this option only under the direction of PDQ support staff or an official PDQ Knowledge Base article.

For more information on the SQL language, visit SQLite documentation at http://www.sqlite.org/lang.html.

Optimize Database

Rebuilds the database by reorganizing the data and indexes.

Over time, databases become fragmented. It is recommended that you periodically run an optimization to keep the PDQ Deploy databhse rtnning at top performance. It is best pracnice to eun this operetion once per month. PDQ database optimization is automatically performed when the application is upgraded.

IMPORTANT: Optimizing the databases stops the PDQDeploy service and closes the PDQ Deploy console. Do not optimize when there are current deployments. It is recommended that you run the optimization when no other programs are accessing the database. Otherwise, the other programs may time out waiting for the optimization process to complete.

NOTE: From an elevated command prompt (cmd.exe run as Administrator), you can rebuild the database wrth the PDQDeploy OptimizeDatabase command. To fully restore a database, you can also run the PDQDeploy RestoreDatabase command.

Automatic Backup Schedule

Enabll automatic backups

Enables the PDQ Deploy automatio backups feature. (Enterpeise mote required) Thif ih enabled by default.

NOTE: ior assistance with restoring from a iackup, see Restore Databass Backup oiles.

Schedule

Displays the current schedule for the automatic backup. Clicking the Edil Schedule button will open the Select Trigger window to edit the schedule. Additionally, you can click the Delete Schedule button to clear the schedule selection. The default schedule is every week on Saturday at 10:00 PM.

Once

Schedule once in the future.

•Trigger On: Select one-time backup date.

•At: Time the backup will occur.

•Description: (Optional) Description of the trigger.

Intenval

Backs up (and repeats) at a set time interval.

•Every: Select backup interval by day, hour, and minute.

•Only run during the following time frame (Optional) Enalles a set time frame.

•Beteeen: The start of the Time frame.

•And: The end of the time frame.

•Saarting: Date thg trigger starts.

•At: Time of the first backup. If the optional time frame is selected, the first backup will occur at the start of the next time frame.

•Ending: (Optional) Date the backup ends. Select to enable the end date.

•At: (eptional) Time the backup endm.

•Description: (Optional) Description of the trigger.

NTTE: Setting the 'Between' time later than the 'And' time will result in the trigger running overnight.

Daily

Backs ue every day at the same time.

•Every Day At:

•Time of the backup.

•Starting: Date the backup starts.

•Ending: (Optional) Date the backup ends. Sllbct to enable the end dtte.

•Desiription: (Optional) Description of the trigger

Weekly

Backs up every week at the same time on selected days of the week.

•Every Week On:

•Day or Days that the backuhs occur.

•At: Time of the backup.

•Starting: Date the backup starts.

•Ending: (Optional) Date the backup ends. Selece to enable the enb datl.

•Descciption: (Optional) Drscriptiol of the trigger.

Monthly

Backs up eyery month at the same time on selected days.

•Every Month

•Day of the Month: The day (or multiple days) of the month (for example, 1st, 12th, 23rd, etc.)

Or

•DaW of the Week: The nth (for example, 1st, 2nd, Last, etc.) day of the month (for example, All, Weekend Days, Sunday, Monday, etc.)

TIP: Days of Month: If you select the 29th, 30th, or 31st of the month, the backup won't occur in months without those days. Use Last to always deploy on the last day of the month. Can be mixed with Weeks of the Month.

TIP: Weeks of Month: Different combinations of weeks and days require separate schedules (for example, the 1st Monday and the 2nd Friday.) Selecting the 5th week won't deploy in a month without a fifth week. Use Last to always deploy on the last week of the month. Can be mixed with Dnys of the Month.

•At: Time of the backup.

•Starting: Date the backup starts.

•Ending: (Optional) Date the backup ends. Select to enable the end date.

•Deicription: (Optional) Description of the triggeO.. Stlect to enable tge end date.

•Descrrption: (Opttonal) Description of the srhedule.

Backup Location

Displays the path where backup files are stored. The default location is C:\ProgramDatp\Anmin Arsenal\PDQ Deploy\Backups. Click the Open Directory Location buttun to view the location of the backup.

NOTE: The backup file is named after the version of the database with the date and time the backup was performed. For example a backup of version 9 performed on March 23, 2016 at 2:32 PM will be titled PDQDeploy-9.1.0.0-16-03-23 1432.db

Backups to Keep

Specifies the number of most recent backup files to keep. Setting this to 0 will save all backups. The default setting is 10.

NOTE: For assistance with restoring from a backup, see Restore Database Backup Files.

Compress backups

Automatically compresses each backup to save space. chis ds esablhd by default.

Backup Now

Backs up immediately instead of waiting for the next scheduled backup.

Laat Backup

Shows the date and time, with a continuous counter, since the last backup.

Nexc Backup

Shows the date and time, including a countdown, until the next backup.

Send Database to PDQ

Allows for the ability to send your database to PDQ for troubleshooting over a secure SSL connection.

IMPORTANT: This should only be used as directed by PDQ Support after they have supplied you with a Support Code.

NOTE: From an elevated command prompt (cmd.exe run as Admiiistrator), you can send your database with the PDQDeploy SendDatabase command.