SQL 2008 Express to Standard or Enterprise upgrad...

sayahdo · ‎08-23-2010

Is there any documentation out there on how to upgrade from a SQL 2008 Express to STD or Ent SQL instance (64 bit)

I ran through the Edition upgrade, Via the SQL install Maintenance Screen on the vCenter Server. The SQL instance was upgrade to Enterprise 64bit with out to many drama’s

But from then on the vCenter has been running like a dog!

First there were permission errors and the ODBC had to be recreated and vCenter server logon account changed

From then on the vCenter service stops just about every hour

The 5min rollup task in SQL Server agent won’t run, saying there is a lock on the file, even with vCenter service shut down, it still won’t run

The log file ballooned to 25GB+ twice now, requiring the vCenter service to be shut down and a shrink run on the log file

We wanted to change from Express to STD or Ent because we kept hitting the 4GB DB limit.

I wondering if it is easier to uninstall SQL 2008 Express

Install SQL 2008 STD or Ent

Restore the DBs

Restore permissions

Confirm the ODBC connection

Repair vCenter to recreate the SQL Server Agent Tasks

Thoughts

Thanks

Mike

pcerda · ‎08-23-2010

Hi,

There is a path to upgrade from SQL Express to SQL Server 2008 R2 (32-bits only):

http://msdn.microsoft.com/en-us/library/ms143393.aspx

But, as you said, it's easier on this way:

- Stop vCenter Server service

- Make a backup of the DBs

- Uninstall SQL 2008 Express

- Install SQL 2008 STD or Ent

- Restore the DBs

- Restore permissions

- Check ODBC DSN connection

- Start vCenter Server service

Regards / Saludos

-

Patricio Cerda !http://www.images.wisestamp.com/linkedin.png!

VMware VCP-410

Join to Virtualizacion en Español group in Likedin

See My Blog

See My Linkedin Profile

-

Si encuentras que esta o cualquier otra respuesta ha sido de utilidad, vótalas. Gracias.

If you find this or any other answer useful please consider awarding points by marking the answer helpful or correct. Thank you.

Regards / Saludos - Patricio Cerda - vExpert 2011 / 2012 / 2013

sayahdo · ‎08-23-2010

Thanks for the quick reply Patricio

What abou the VMware tasks asscioated with the SQL Server Agnet.

Would these still be there after a uninstall and reinstall?

Would you have to run a repair on vCenter to get these put back in??