SQL Server 2000 Enterprise Edition upgraded to SQL 2005

5 pts.
Tags:
Microsoft SQL Server 2000
SQL Server
SQL Server 2000 migration
SQL Server 2005
SQL Server migration
Web hosts
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following