How to do POS DB Restoration

We have noticed ongoing problems with POS Restoration. Being familiar with the appropriate steps for different situations and POS versions is essential.

Prerequisites:

Backup must be generated by the POS Application
Manually taking backups using SQL Server Management Studio or attaching database files are not covered in this article.

Different Scenarios for Restoration of POS DB

Scenario 1: Restoring in the same application environment

Important pre-requisites to ensure:

The POS program files were there and the POS was working fine before it crashed. This means we have the latest files from when the POS was last used.
If it exists then the POS Database should be dropped before proceeding to Restore.

After copying files, use our POS Restore utility for restoration.

Scenario 2: Restoring in a fresh machine

In this scenario, users typically choose between two options: Restore or Copy the application folder from a customer-managed backup location and Fresh installation.

In either case, the first step is to determine the POS version that was in use before the crash.

Important Considerations -

Does POS Application File set Backup Exist

Retrieve the POS folder from your personal backup location.
Copy it to the desired location.
All required Services and schedulers need to be created manually.
If POS Version < 2.15.0: Restore using Restore.exe from the POS folder.
If POS Version ≥ 2.15.0:
- If POS version < 2.17.0: Download the Restore Patch ZIP from https://support.ginesys.in/downloads/current/POS/DBRestore_2.15.0.zip
- If version between 2.17.0 and 2.17.5: Download from https://support.ginesys.in/downloads/current/POS/DBRestore_2.17.0.zip
- If version ≥ 2.17.6: Download from https://support.ginesys.in/downloads/current/POS/DBRestore_2.17.6.zip
Unzip and copy the files to the POS folder, then use the DBRestore utility as before.

If POS Application Files Backup Does Not Exist (Fresh Installation):

For POS Version < 2.17.0:
- Download and Install old POS Pack from https://support.ginesys.in/downloads/current/POS/GINESYS_POS_Pack_1_146_2.zip
- Download the Restore Patch ZIP from https://support.ginesys.in/downloads/current/POS/DBRestore_2.15.0.zip
Unzip and copy the files to the POS folder, then use the DBRestore utility as before.

For POS Version ≥ 2.17.0:
- Download and Install new POS Pack from https://support.ginesys.in/downloads/current/POS/GINESYS_POS_Pack_2_17_0.zip. After installing,
- If version between 2.17.0 and 2.17.5: Download from https://support.ginesys.in/downloads/current/POS/DBRestore_2.17.0.zip
- If version ≥ 2.17.6: Download from https://support.ginesys.in/downloads/current/POS/DBRestore_2.17.6.zip
Unzip and copy the files to the POS folder, then use the DBRestore utility as before.

Make sure to download and copy the correct patch. Using the wrong patch can cause errors due to the tight integration of the backup logic with the Restore application. Accurately identifying the POS version prior to the crash is critical to follow these guidelines effectively.

Need Help?

Should you face any issues after implementing these steps, please reach out to Ginesys support for further assistance.

Your attention to this critical process is greatly appreciated.