Zephyr Server/Data Center Backups and Restore
There are currently two objects that can be backed up:
| Object | Description |
|---|---|
| Data | Typically backed up and stored in a tar.gz file. |
| Attachments | By default, attachments are not stored in the tar.gz file. They are placed in the <zephyr_install_dir>/zephyrdata folder. |
Please ensure you are logged in to the machine on which Zephyr Server is installed to access the restore processes. You will need to be logged in to your database server to back up the database data separately. Attachment script files must be run with appropriate permissions.
It is highly recommended that you consistently back up your Zephyr attachments and database.
Backup & Restore
Additional Note
Linux users note that all utilities must be run as root. Use the sudo command for root permission.
The following steps will need to be followed to back up, restore and schedule your database:
Database Backup
Backup: Instructions take a native backup from the database without attachments
MySQL
mysqldump -u [uname] -p[pass] db_name > db_backup.sql
Example: mysqldump -u itcc -itcc_backup itcc > itcc_backup.sql
mysqldump -u itcc -itcc_backup dversion > dversion_backup.sql
Oracle
exp ITCC/ITCC_password file=itcc_backup.dmp
Please check Oracle standard schema documentation restore steps for your database version.
MSSQL
Please contact your DBA for instructions or follow the steps mentioned in the link below for backup
https://technet.microsoft.com/en-us/library/ms187510(v=sql.105).aspx
Database Restore
Restore: Instructions to restore the native backup
MySQL
mysql -u [uname] -p[pass] db_name < db_backupfile.sql
Example:
mysql -u root -proot itcc < itcc_backupfile.sql
Oracle
Please check Oracle standard schema documentation restore steps for your database version.
MSSQL
Please contact your DBA for instructions or follow the steps mentioned
in the link below for restore and backup
https://technet.microsoft.com/en-us/library/ms188312(v=sql.105).aspx
Scheduling
The scheduling utility that only backs up the database without backing up the repository and trend data. Use this utility only if instructed by Zephyr support.
Usage:
schedule.bat [db name] [db username] [db password]
[output file name and path] [zephyr installation path]
Example:
schedule.bat ITCC root root
C:\mybackup\partial-db-backup.sql C:\Software\Zephyr\