Database Maintainence

Scheduled Backup Setup
      Database backup is setup to run on a schedule, usually daily. PRAR will configure your database to be setup in such a schedule and configure all the required parameters for the backup software.

Index Maintenance
      For all types of databases, PRAR regularly conducts maintenance on the indexes. This improves the performance of queries and keeps the database in a healthy state.

Database Security and Permissions
      PRAR helps you to setup users and their roles. It maintains the administration users and controls their passwords. Security checks are conducted to detect any holes in the system accessibility.

Database recovery/restore from backup
      If a restore is requested, PRAR will conduct one using the database backups from disk/tape. In the unforeseen event of a database crash, a recovery will be done from the backup disk/tape as the case maybe.