Symptoms
On one of dev servers K2 DB size is about 5.2 Gb. Can you please advise how to reduce it. Old data can be deleted.
Server.assembly table is the largest (4 GB).
Diagnoses
Stored Procedures are shipped with K2, to scrub database.
Resolution
We have stored procs that will effectively turn the database into a fresh install of K2.
Disclaimer: Use at your own risk. These Stored Procs will wipe the database to an 'as new' state and as such, you must assume that all database data will be lost.
I strongly recommend to do a full backup of the K2 database prior.
The stored procedures are:
- Server.wipeall
- ServerLog.wipeall
- Form.wipeall
ServerLog and Server use the Truncate command, so they are not recoverable.
