Using the K2 Workspace Archive facility
As your K2 workflow processes are run the K2ServerLog is used to log information about your workflow processes. This database will grow in size over time and you will no doubt have to do some archiving on this database. Out of the box the K2 Workspace provides an Archive facility that can be leveraged to enable an archive to be run on the database specifying a given date range.
Before I go into the steps that can be followed to use this feature remember the K2ServerLog database is used for your out of the box and probably custom reports. Therefore you need to take this into account when choosing the date range for your archive.
To implement your archive you will need to carry out two steps:
- Create a blank database to be used as the archive database
- Use the workspace to start the archive.
Create a new blank database
I appreciate there are many ways to do this, below is one
- Open Microsoft SQL Server Management Studio
- Right Click Databases and select New Database
- Enter your preferred values
Use the K2 workspace to carry out the archive
- Open the K2 workspace
- Navigate to Workflow Server -> Archiving
- Choose your authentication method
- Select the K2ServerLog Database as the Log Database
- Enter the date range to archive
- Select the blank database as the archive database
- Close the dialog and that’s it! K2 will create the required tables if they do not exist in the selected database and carry out the archive.
