I have read here several hints how to move a virtual center database to the full SQL version.
I would like to move my VC database from a SQL2000 server to a SQL2005 express edition.
Why I would like to make my VC server independent of any physical server not relying to a other server.
NO. That's not a good idea. Why do you want to do that? It's better to keep it on SQL 2000, rather than move to SQL Express.....
Besides, it pretty much requires a DBA to do it, it's not that simple. Lots of things to take into account... the differences in capability is one thing. SQL Express 2005 is NOT supported DB for VC.
Sorry to hijack your question, but I'd also like to know the answer to this one. I have an idea, but would like to know "for sure". We have a physical VC server but with the SQL2000 database server inside ESX. So when we have issues with the virtualization environment that causes the SQL server to go duh, then we lose VC as well. We would also like to keep VC totally separated for this reason (again, very small enviroment; 3 Foundation hosts and 14 VMs).
I would like to follow up my request. Until now I have not changed anything.
Situation: Vcenter Server is installed on a PC (not VM) and database is on a SQL2000 physical box. I have setup SQL2005 on a VM.
I need to retire the box with SQL2000 soon. The question is to where should I move the Vcenter database? I have read here some hints that it's not a good idea to have the database on a VM.
What do you think.^?