Just wanted to join the list of growing users who are using SQL 2005 as a virtual machine. It was actually an easy conversion. Unfortunately, we had to run the p2v tool, due to some 3rd party db apps that were installed on the server. The db's were already on the SAN and with a small OS footprint, I was able to clean the server up as much as possible before running the p2v tool. Not ideal, but I was happy with it.
Originally a Windows 2000 server running SQL 2000 Standard, our upgrade consisted of an OS and SQL upgrade. Storage is Dell/Equallogic iSCSI - see previous posts. So a quick recap -
Stopped all SQL jobs, activity, services.
Backup server..SAN snap of db's.
Run physical to virtual tool on SQL server.
Shutdown 'old' physical machine.
Power on vm, verify all vm settings.
Snapshot of VM.
Upgrade OS from 2000 to 2003.
Snapshot of VM
Upgrade SQL 2000 to 2005, install SQL SP3
SAN snap of db's.
Snap of VM.
Upgrade databases from 80 Compatibility mode to 90 Compatibility mode.
Verify and test.
Our db environment for this server is about 80-100gb of data, nothing outrageous. The new vm is running great. We'll see how this week goes. Thanks VMWare and Dell/EqualLogic. I'm now one less old physical machine, with new redundancy and better performance. Exchange should be fun.
Sunday, January 11, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment