How to backup a PTP Accounts Production SQL Database using the Database Manager

Introduction

This topic explains what is required to backup a PTP Accounts Production SQL database using the PTP Database Manager. It covers making a manual backup to IRIS\Data\SQLBAK directory. This then allows the user to make a copy of the DATA folder ensuring all the user defined data in PTP Accounts Production is backed up.

1. Right-click on the PTP Accounts Production Short Cut, select Open file location now locate the file:

2. Right-click on this and select Send to Desktop (Create shortcut)

• Once steps 1 and 2 have been competed they will NOT be needed to done again.

3. Double-click on the Icon (Iris.DatabaseManager.exe) If prompted login as Master.

This will open the PTP Database Manager.

•  It is advised that you make NO changes here and leave all defaults as they are.

4.  Click Run Now.

 A green progress bar moving across the screen:

After a short while you will see a message SQL backup completes successfully. You can now close this window.

• As per the information at the beginning of this topic, PTP recommends backing up the SQL database into the IRIS\DATA folder, then using the normal backup regime to back up the DATA folder, thus ensuring a complete backup of all PTP data.

Back to top