5 pts.
 SQL Server 2000 Enterprise Edition upgraded to SQL 2005
I am researching different Hosting companies with dedicated servers that we can look at moving to. I need to know some information when I am looking at these different companies about the SQL server. We are currently running SQL Server Enterprise 2000. I have seen that the companies are offering MSSQL 2005 in Express, Workgroup, Standard or Enterprise. Which of these versions can we move to and not interrupt service to our clients?

Software/Hardware used:
ASKED: December 18, 2008  7:21 AM
UPDATED: December 20, 2008  6:33 AM

Answer Wiki:
You can move to any of them provided that the edition can support your workload. Express only supports 1 Gig of RAM and databases up to 4 Gigs in size and 1 CPU. Workgroup only supports 2 Gigs of RAM and 2 CPUs. Standard supports up to 4 CPUs. Enterprise supports up to 32 CPUs.
Last Wiki Answer Submitted:  December 20, 2008  6:33 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _