Quick HowTo

Windows error log

MSSQL$VIM_SQLEXP
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database

Solution

VMware knowledge base

MSSQL CLI

start cmd as administratot

sqlcmd -S np:\\127.0.0.1\pipe\MSSQL$VIM_SQLEXP\sql\query

(Exact string can be recovered for the MSSQL admin GUI if it is not the same)

list DBs

EXEC sp_databases
go

Change DB

use VIM_VCDB;
go

Dry run

Copy paste SQL script from KB entry.

Cleanup

Set DELETE_DATA to 1 as below in the script and re-run

-- ######### USER CONFIGURABLE PARAMETERS ########################
-- 0 = COUNT ONLY; 1 = DELETE ROWS
SET @DELETE_DATA = 1

10G DB cleanup took cca. 3 hours