K2 BLACKPEARL PRODUCT DOCUMENTATION: USER GUIDE
Workflow Service Management - Archiving

Workflow Server - Archiving

The Archiving feature is used to archive data that can be restored at any point in time

   

Fig. 1. Archiving Options screen

The first step in Archiving data from the Workflow Server is to select the SQL Database containing the Log data. Click on the Select button next to Log Database.

   

Fig. 2. Log database selection screen

Select the log database and click OK. Then select the From and To dates to be used for the archive.

   

Fig. 3. Archiving Options screen

Now select the Archive Database by clicking on the Select button next to Archive Database and select the database to which the data should be archived.   

   

Fig. 4. Archives Database

The Archive button at the top is now enabled. Clicking on the Archive button performs the data archive, presenting the user with a log of the archive activity. Exit the log screen by clicking on the Close cross or the OK button once the archive process is done

   

Fig. 5. Confirmation of archive

The Archive details are displayed.

   

Fig. 6. Archive details

Option What it is How to use it
Log Database The SQL Server Database name of the required Log Enter the database name to be Archived OR click the associated Select Button
Provides a list of databases on the SQL server Select the required database from the list
From Date: The starting date of the period to be archived Enter the date OR click on the calendar icon and select the required date
To Date: The ending date of the period to be archived Enter the date OR click on the calendar icon and select the required date
Archive Database The SQL Server Database name that will receive the data being archived Enter the database name OR click the associated Select Button
Provides a list of databases on the SQL server Select the required database from the list
Archive Selected Database Button Click on the Button
Restore Selected Database Button Click on the Button
Only Completed and Deleted instances are archived at a certain point in time.
When using the API and specifying a date and time for the From and To dates, Archiving will disregard the time and archive the entire day for the From and To dates.

Database Restore

To restore a database, simply select the database to be restored and click on the Restore button at the top.

   

Fig. 7. Restore database

Clicking on the Restore button performs the data restoration, presenting the user with a log of the restore activity. Exit the log screen by clicking on the Close cross or the OK button once the restoration process is done

   

Fig. 8. Restore confirmation

Permissions

The following permissions are required when archiving data:

User Permissions:

K2 Server Service account:

The user requires K2 Server Admin rights to open the Archive node in Management Console. The K2 Server Service account is then used to retrieve data from the K2ServerLogDB and archive the data in the custom created archiving DB. The same rights are applied when performing the restore action.

 

 


K2 blackpearl Help 4.6.11 (4.12060.1731.0)