Sql-server – Does MSSQL 2000 run in VMWare ESX

sql servervirtualizationvmware-esx

Does MSSQL 2000 run in VMware ESX? We are planning on going into a virtualized environment and are wondering if main production database will run in VMware ESX. We cannot upgrade the SQL version.

Best Answer

Yes, it runs just fine in VMware - hopefully it's a lightly loaded database server rather than a multi-terabyte monster!

Ideally, you'd want a fresh install of Windows and SQL Server 2000, but failing that a P2V will work. Brent Ozar refers to it as taking care of dinosaurs:

http://www.brentozar.com/archive/2008/08/sql-p2v-what-really-killed-the-dinosaurs/

and

http://www.brentozar.com/community/virtualization-best-practices/

The only time I got caught out with this approach was when a SQL2000/Windows2000 box was cloned (P2V), and then taken from its original domain to a new domain. SQL got a bit confused as the servername is embedded during install.

Related Topic