asked on

VMWare SQL Express 10GB limit reached

I am getting errors on my vsphere server that states we have hit our SQLExpress size limit. Because of this we can not connect to the vcenter server. I have loaded the SQL Management Console and it does show that we have 0% space available. I have looked to remove old VM's that not is service any longer, which reduced the space used on the Storage server, but didn't free any DB space. What are my options;

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

Look at your Task and Events table ? How large is Task and Events table in the SQL DB ?

What version are you using ? - vSphere ?

How many VMs and how many Hosts do you have ?

sfletcher1959

ASKER

Version is 5.5

17 VM's (2 off, but still in inventory)

Not sure how big the T&E table is, because I am doing a backup prior to shrinking files (log).

I am following "Purging old data from the database used by vCenter Server (1025914)" KB article. Hopefully that will provide some space to help. Ultimately want to upgrade from SQLExpress to SQL Sever 2012. Is this an option with VM and are there any issues with doing this. Also is it better to install a full version of SQL 2012. Backup from SQLExpress and restore to the new full version or just upgrade the existing version?

SOLUTION

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Member_2_231077

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

Do you require any more additional help from Expert Exchange Experts, so you have the knowledge to be able to select a solution and close the question, which is the expected behaviour at Experts Exchange when a Question has been asked.