How to Archive Audit Report Data on your RPOS6 RposAuditDB

How to Archive Audit Report Data on your RPOS6 DB (RposAuditDB)?

  1. Right-click the GoFrugal RPOS6 icon.


  2. Click Properties.
  3. The GoFrugal RPOS6 Properties screen is displayed.



  4. Click Open File Location.
  5. The GoFrugal RPOS6 file location folder is displayed.



  6. Double-click the ArchiveData.exe icon.
  7. The Archive Database screen is displayed.



  8. In the Archive Database till the field, enter the date till you want to archive the data.
    Note: It is recommended that select the end date of the month and data should be at least 3 months old from the current date.
  9. Select the option Archive Audit (RposAudit DB).
  10. Click the option Create Database.
    Note: It is recommended that, create a database first before the Archive Audit (RposAudit DB) archive process.
  11. The Compress Data screen is displayed.



    Note: The Compress Database process takes few minutes to finish.
  12. A message Archive Successfully completed is displayed.



  13. Click OK.



  14. Click the option Archive.



  15. The Archive Audit (RposAuditDB) process starts.
    Note: The Archive Audit process takes few minutes to finish.
  16. A message Archive successfully completed is displayed.



  17. Click OK.
  18. The splitData screen is displayed with a message Do you want compress RposAuditdb_Archive database?
    • In the SplitData screen, click from the options given below
      • Yes - if you want to compress RposAuditdb_Archive database. Click Yes.
      • No - if you do not want to compress RposAuditdb_Archive database.
  19. The Compress Database screen is displayed.



  20. The splitData screen is displayed with a message Do you want compress RposAuditdb database?.
    • In the SplitData screen, click from the options given below
      • Yes - if you want to compress RposAuditdb database. Click Yes.
      • No - if you do not want to compress RposAuditdb database.
  21. The Compress Database screen is displayed.



    Note: The Archive process takes few minutes to finish.
  22. The Backup Archive screen is displayed with a message Do you want BACKUP RposAudit_Archive database?.
    • In the Backup Archive screen, click from the options given below
      • Yes - if you want to compress RposAuditdb_Archive database. Click Yes.
      • No - if you do not want to compress RposAuditdb_Archive database.
  23. The Archive Database screen is displayed with RposAuditdb_Archive completion message.



  24. Click Close.
Note: To follow the steps for viewing archive data for RposAuditdb_Archive click Viewing Archive Data

    • Related Articles

    • How to Archive your Transaction Data from your RPOS6 DB (Medishopdb)?

      Steps for Archive Data - Archive Transaction (Medishopdb (Production Live Data)) Right-click the GoFrugal RPOS6 icon. Click Properties. The GoFrugal RPOS6 Properties screen is displayed. Click Open File Location. The GoFrugal RPOS6 file location ...

    • How to archive a data base?

      Archive Data screen is used to move all the transaction data to a new database. It allows you to move old data to archive data. The old data is broken in Quarter-wise (3 - months) and after completion, they are compressed to avoid performance issues. ...

    • How to attach Database during Master DB Corruption?

      Steps to attach Database during Master DB Corruption: The steps for attaching  the database during corruption  are given below - Click the C:\ drive and open Program Files.      2. Select the Microsoft SQL Server folder.      3. Open the MSSQL.1 ...

    • How to view the Archived database?

      Viewing Archive Data Steps to View Archive Data Click Tools > Business Intelligence > Load Archive. A message Do you wish to Change to ARCHIVE Database? is displayed. Click Yes. The Archive Database screen is displayed. Note: In the Archive Data only ...

    • What is Data Purge?

      Data Purge Data purge is the permanent deletion of the unwanted/old data. Purge process is ideal for customers who want to manage their storage (disk space) or database size efficiently by permanently deleting the data that is no longer required by ...