Backup

Automatic Test Server Update on Windows V 1.2

For PowerSchool 5.2.x (Oracle) on Windows ONLY.

This customization will help you automate your live server backups and your restores to a test server.

customscripts/cleanArray.bat:
This script is called by updateTestServer.bat automatically and does not need to be scheduled for regular use.
- What it does:
1. Cleans out the server array information
- Useful when:
1. Test environment is a single sever while the live environment is multiple server
2. Test environment is on a newer version of PowerSchool

Mac OS X Backup Script

The attached shell script will run automatically every night to create a single file backup of PowerSchool so that you can do an off site backup in case the hard drive in your server crashes.

1. Create a folder on the top level of your hard drive named /PowerSchoolData. If you upgraded from PowerSchool Premier 5.1 that folder will already exist.
2. Put the attached script in the /etc directory on your server.

Server Backup Script

When 5.2 was introduced using the Oracle Database, new management features where added. This included the ability to restore our own servers. The problem with this is there is no single file that can be copied directly off the server as a backup. Also due to the flashback technology of Oracle you may not be able to backup the Database by normal backup means because the files are in use.

cleanupBackups.bat

Cleans up the backup files on a Windows 2003 Server. Keeps backups that have been created in the last 21 days. Also cleans up transaction logs for the same time period. Edit drive letters for your server.

Syndicate content Syndicate content Syndicate content