COPS Backup ...Cheap Offsite PowerSchool Backup

COPS Backup is simply an elaborate applescript I wrote as a solution for offsite backup of my server's entire PowerSchool folder. Being that I am not a fan of tape backup, and that the PowerSchool folder is relatively small, I figured moving the folder to another building's fileserver over AFP would work nicely. Archived monthly backups are an excellent addition to PowerSchool's built in backup of the active data file.
The script leverages OSX's command-line utility "hdiutil" to create AES-128 encrypted disk images. This way your backups are secure even if others have access to the backup server. Being an applescript, COPS Backup requires you are running PowerSchool on Mac OS 10.3 or later.
I have also created a installer for the program that will walk you through the setup including the option to create a reoccurring (monthly or daily) event in iCal on the server to trigger the backup. And an uninstall script which can be found in the program's folder after the setup.
IT IS NOT RECOMMENED YOU USE THIS SCRIPT WITH POWERSCHOOL PREMIER. Powerschool premier gives a very robust incremental type of backup built in.  However, with that has come much MUCH larger folder sizes that make offloading through the network more problematic.

VERSION 1.5 IS HERE! This release has greatly simplified and streamlined the setup of COPS Backup.  The actual backup process has not changed a bit. So if you are already running version 1.0, no reason to reinstall. That is unless you want to check out the SWEET setup interface I built in xcode.

To be specific, the COPS Backup script will do the following whenever run:
  • Shutdown the PowerSchool application.
  • Create an compressed and encrypted disk image file from the contents of the PowerSchool folder. The file will be named using the current date.
  • Restart the PowerSchool application.
  • Mount the AFP share where the backups will be stored.
  • Move the backup file to the share, then eject the share.
  • Send a notification email to an email address/es specified at the time of installation. (Optional)

The script will also do a fair amount of error checking on itself. It is designed to quit the backup process, and send a notification email containing any errors it encountered.
Please refer to the Read Me.pdf included in the zip file for full details and tips on running the app.

Download COPS Backup version 1.5

COPS Backup is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY.