What is a Store?

The BPA Platform server contains a data store where information, such as configured tasks, are stored.

Two store types are available:

► Microsoft SQL Server Store — Holds the Store in a SQL database. This can be in a local or remote SQL Server installation. (RECOMMENDED)
► Internal Store — Holds the Store locally on the installed computer's hard drive. Typically, this is c:\iwdb.
  Internal Store Microsoft® SQL Server Store
Requirements Available space on disk only

Microsoft® SQL Server™ 2014 or higher
Speed Very fast, but can slow as usage increases Fast and scalable, even on busy servers
Reliability Reliable, but corruption can occur in rare circumstances Very reliable, relies on SQL Server Integrity

Maintenance

Maintenance takes time to run due to de-fragmentation Maintenance is very quick as de-fragmentation is performed by the database administrator
Backup Backup must be made by backing up the Backup sub-folder of the BPA Platform Internal Store Backup is left to the database administrator who is maintaining the SQL Server backup

Backing Up a Microsoft® SQL Server™ Store

It is recommended you add the whole SQL Server database as well as the SQL Server store to your standard database backup routines — refer to your database administrator for more details.

To manually backup your SQL Server store, refer to the following Microsoft SQL Server article — https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-2017

Finding the Store Name

By default, the store is named BPAPlatform. However, you can choose to customise this at configuration time. To find the custom database name, do the following:

  1. Launch the ConfiguratorClosed You use the Configurator to install third-party software that may be required by available tools. Connection to required agents are also configured here. Note that you can only launch the Configurator if logged into the machine with Administrator rights..
  2. Expand the following nodes: Server > Store > Configuration.
  3. Enable Change store configuration then Connect to / Create an alternative Microsoft SQL Server Store.
  4. Click Next.
  5. The database name is in the Database text box.
  6. Click Close then No to not save any changes.

Tip: Ensure Maintenance is run frequently on your BPA Platform server to ensure data is up-to-date — see How to Run Maintenance.

Backing Up a BPA Platform Internal Store

By default, the internal store is held in the c:\iwdb folder unless a different folder is specified at configuration time. To find the custom location, do the following:

  1. Launch the Configurator.
  2. Expand the following nodes: Server > Store > Configuration.
  3. Enable Change store configuration then Connect to / Create an alternative internal store.
  4. Click Next.
  5. The folder location is in the text box.
  6. Click Close then No to not save any changes.

To backup the store, do the following:

  1. Stop all BPA Platform services (typically, those starting with BPA Platform).
  2. Make a copy of the files in the relevant folder.
  3. Restart the BPA Platform services.

Tip: Ensure Maintenance is run frequently on your BPA Platform server to ensure data is up-to-date — see How to Run Maintenance.

Tip: Create a scheduled job to create automatic backups of the internal store — refer to your Windows Server documentation.