Zephyr Server/Data Center Backups and Restore
Please ensure you are logged into the machine on which Zephyr Server is installed to access attachment backup/restore processes. You will need to be logged into your database server to backup the database data separately. Attachment script files must be run with appropriate permissions.
It is highly recommended that you consistently backup your Zephyr Attachments and Database.
Backup & Restore
Important
Additional Note
Linux users note that all utilities must be run as root. Use the sudo command for root permission.
Back up the Attachment
Navigate to
{ZephyrDir}/zephyrdata.Create a Backup by copying the entire Zephyrdata folder and storing it in a safe location.This will ensure that all attachments are backed up securely.
Note
These steps are part of the overall Backup, Restore, and Scheduling process for your database and attachments.
Restore Attachments
Locate Backup by finding the previously backed-up zephyrdata folder.
Restore to Zephyr Directory by copying the backed-up zephyrdata folder into the Zephyr installation directory:
{ZephyrDir}/zephyrdata.Confirm Restoration and make sure that all files are copied successfully and that permissions remain intact.
The following steps will need to be followed to Backup, Restore and Schedule your database and attachments:
Copy the zephyrdata folder backup step in {ZephyrDir}/zephyrdata.
Database Backup.
Scheduling
Step 1: Database Backup
Backup: Instructions take a native backup from the database without attachment
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
Step 2: 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
Step 3: Scheduling
The sheduling 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\