Wednesday, 1 August 2012

Backup Methods

There are numerous options for archiving backups from CPM to external systems. Please contact Rexson with any details needed to set up your preferred solution.

External Drive

The simplest method is to plug in an external hard disk or flash drive. A script is available to automatically mirror the content of C:\SqlBackup\CPM to your external drive.

Pushed from ColorPoint

The system backups are run daily on CPM and the last 7 are kept. The backup script has a command to copy these files to a network folder every day after the backup runs. To enable this all we need to do is set the folder location in an environment variable. The script automatically removes older backups from the network folder, so you may want to copy out the most recent once a week for long term storage if needed.

Please advise Rexson of the backup location either as a UNC path (e.g. \\server\folder-for-backups) or as a mapped drive (e.g. X:\folder-for-backups). As long as the user running the scheduled task for the backup has permission to write to this location, the backups will take place automatically.

Pulled by a task on your Network

If the previous method is not suitable for your infrastructure then backups can be retrieved directly from CPM. The folder C:\SqlBackup is shared. The CPM sub-folder contains automated backups and CPM-User contains user initiated ad hoc backups. The local user account CustomerAdmin can be used for authentication.

An sshd server runs on CPM. This can be configured to allow SFTP access to the backups. 

Other Methods

Backups may also be sent from CPM via FTP/SFTP by Rexson Agent. This is a paid add on.