Database Backup (MS SQL Server)

Data stored in PAM360 database is of critical importance. In any production environment, there would be constant requirements for backing up the data, for either reference purpose or disaster recovery. You can schedule tasks to back up the database contents periodically. The backup will be stored as a .bak file by default in the host, where the SQL server is running. All the sensitive data will remain encrypted in that file.

The rest of the document allows you to understand two types of Database Backup in detail:

  1. Scheduled Backup
  2. Instant Backup
  3. Offline Backup

1. Scheduled Backup

This type of backup allows you to schedule the database backup to be executed at any specific point of time.

Steps to Schedule a Database Backup:

  1. Navigate to Admin >> Configuration >> Database Backup.
  1. In the window that pops up, select a schedule option - day, weekly or monthly.
  2. Select the time frequency (dd:hh:mm) at which the backup has to occur.
  3. The Destination Directory field shows the directory path (<MSSQL_installation_folder>\Backup) in the host where the SQL server is running. The backup will be stored as a .bak file which holds all the encrypted sensitive data. It is recommended that you backup this file to a secure, secondary storage. The backup file will have the file name structure as pam360backup_pam360version_YYMMDD-time.bak.
  4. Click Save. The required backup schedule is created.

2. Instant Backup

You can take a one-time, on-demand backup anytime, by clicking the button Backup Now available in the web interface shown above.

3. Offline Backup

Follow the steps below to take an offline backup of your PAM360 data:

  1. Stop the PAM360 service.
  2. Open the command prompt and navigate to the <PAM360_Installation_Folder>/bin directory.
  3. Execute the command BackupDB.bat.

A .bak file is created with the following file name structure: OfflineBackup_backupdate-time.