Improve company productivity with a Business Account.Sign Up

x
?
Solved

which version of sql server 2005 for a single cpu Windows 2003 server

Posted on 2008-06-26
4
Medium Priority
?
192 Views
Last Modified: 2010-04-18
I will have multiple domains on a Windows 2003 Standard system with 1 cpu.

Which version of Sql Server 2005 should i use?  And this will be an upgrade from Sql Server 2000.

0
Comment
Question by:bobsocks
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:jfields71
ID: 21875487
That depends on what you want or need to do with it.  It appears as if you could actually use the free Express version.  However, it has many limitations.  How much RAM you have and if you need features such as clustering would determine which edition to get.  We ended up buying Standard Edition for our severs.  I used this chart here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
0
 

Author Comment

by:bobsocks
ID: 21875852
I looked at that chart.  My guess was workgroup or standard.

Problem with express is the 1 gig limit on memory.  The system has 4 gig.  There will be no clustering.
0
 
LVL 11

Accepted Solution

by:
jfields71 earned 150 total points
ID: 21875879
Then I would go with Standard.  It removes some of the arbitrary limitations of Workgroup edition (RAM) and gives you some upgrade options.  Should you add more RAM to the system, add more CPUs, or upgrade to a 64-bit OS, Standard will give you better performance.  Basically, it gives you more room to grow if you ever need more than what you have today.
0
 

Author Comment

by:bobsocks
ID: 21877355
Now where do I find info on an upgrade from 2000 to 2005?  Specifically, the best price.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question