With the release of DCS 6.9.2, a store procedure allowing shrinking of partitioned databases was released. This makes this task a lot smoother and easier to run. This stored procedure can be run on older DCS 6.9.x versions that have partitioning enabled on the database, so long as its added manually from a newer install.
Data Center Security
Version 6.9.2 and higher
Executing the SCSPDB Shrink partitions:
2. To execute this query, right click> Execute. This will prompt a new window to input some variables:
3. Each value is as follows:
4. Once the query is ran as a TESTMODE, the outpu will look like this:
Once ready to execute this query, change the value from TESTMODE to SHRINK if the results are to your satisfaction.