SQL options with WinSBS2008 Standard vs. Premium, & Virtualization / HyperV
Posted on 2009-07-14
I have an old Dell 400SC server, long out of warranty, running WinSBS 2003 Std (not R2) serving 10-15 users.
It's been showing its age & slowness for some time, and now is labouring under the extra load of hosting an SQL2000-ONLY-based old version of Great Plains that's recently been added to its responsibilities.
However this Great Plains system will be replaced by something else, likely based on SQL2008, some time this year.
I need to upgrade the server, and will almost certainly go with SBS2008. I'll likely use the existing old 400SC server to host SQL2000, not just until the old Great Plains system is replaced but likely indefinitely to allow access to old Great Plains data.
But I'm having trouble deciding:
1) if the Premium edition is needed. We haven't needed it thus far, even though it's happily hosting a 3rd-party SQL2000-based app. Why is that? What's the purpose of the Premium edition, when SQL is already there (for SBS's Sharepoint & Performance logging stuff)?
2) if we do need to go with the Premium edition, *must* it be run on a separate hardware server, or can WinServ2008+SQL2008 be run in a virtual machine on the SBS2008 server? (ie is HyperV included or available for SBS2008?) Is there an alternative to HyperV that will work with SBS2008?
If I need Premium on a separate/2nd hardware server, I'll still likely need to run another virtual instance of Windows on it to host SQL2000 for access to historical Great Plains data. Ugh...
Many thanks for clarification here,