Backup a Batch Historian database using SQL

The Batch Historian Administrator tool has a function that allows you to schedule regular backups of your active database. However, should the need arise to perform a backup on demand, you can use SQL Server Management Studio, available when SQL Server is installed or as a download from Microsoft.

The steps outlined here are independent of the SQL version. For exact steps for your SQL version, please refer to the SQL Server Management Studio help.

Log on to the Batch Historian workstation as Windows Administrator, and then log on to DeltaV as the DeltaV Administrator.
Stop the Batch Historian.
1. Run the Batch Historian Administration tool.
  Start → DeltaV → Batch → Historian Administration Tool
2. Select Server → Connect.
3. Select Server → Start/Stop Historian.
Close the Historian Administration Tool and all other Batch Historian clients on all workstations, for example, Batch History View.
Start SQL Server Management Studio.
Use the database backup utility that is available in the SQL Server Management Studio.
Connect to the Batch Historian Server node.
Drill into the Batch Historian Server node name → Databases → DVHisDB.
Right click and select TasksBack Up...
This launches the SQL backup wizard.
Complete the fields on the wizard pages with the following options:
- Database = DVHisDB
- Backup type = Full
- Backup destination = Use the format: Drive:\Directory Path\Filename
- Backup name = Provide a unique name for each backup.
The rest of the options will depend on the SQL version and your preferences.
At the end of the wizard, click OK and the backup task will begin.
Once the backup completes, you can restart the Batch Historian server using the Batch Historian Administration tool.
1. Run the Batch Historian Administration tool.
  Start → DeltaV → Batch → Historian Administration Tool
2. Select Server → Connect.
3. Select Server → Start/Stop Historian.