SQL Express is limited to 10G database size.
After deleting and truncating data you need to shrink the db file. You should consider to migrate to VCSA after get VCS up and running.
My questions sense im still a little new to this how and will it be safe to just remove the data.
Welcome to the Community,
In most cases I saw, the space issue was related to the "VPX_EVENT" table, i.e. the setting to keep events for a large number of days.
I'd suggest that you check which SQL table occupies that disk space, and then proceed with the appropriate action.
For the above mentioned table, see e.g. https://kb.vmware.com/s/article/1025914
Hint: To find out the space occupied by each table, you may run the SQL questy from step 5 in https://kb.vmware.com/s/article/2005333.
In any case, ensure that you have a database backup prior to taking any actions!
your Topic says "SQL Enterprise".
In your text you referrer to a 10GB limit which match perfectly to SQL Express.
So what kind of DB type your using? It is possible to forget to enable automatic increase for Transaction Logs/DB also in SQL Enterprise.
To find out which table is the largest...start your SQL Studio. With the name of your largest tables you can query the vmwar kb or just ask here. Most likely its a common problem
- Statistic data*
- Events/task tables
*If youre using SQL Express than there are no scheduled sql jobs availalbe which can be a problem if you have a lot of VMs and set the stats level to high within vCenter.
PS: If you are running a VDI production environment you should have active SnS so you can call VMware GSS for help.