Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ett9300
Starting Member
12 Posts |
 Posted - 2011-12-07 : 17:44:18
|
| I am currently running SQL 2000 Enterprise Edition on Windows 2003. I want to upgrade the server to Windows 2008. How do you determine which version of Windows 2008 and SQL 2008 to run? I was thinking of running Windows 2008 64 bit R2 Enterprise and SQL 2008 R2 standard (64-bit) x64. Do you foresee any problems?Any suggestions are greatly appreciated.Thanks.Diane |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ett9300
Starting Member
12 Posts |
Posted - 2011-12-07 : 23:46:19
|
| Thanks Tara. We have not purchased the licenses for Windows and SQL. We want to support 200 concurrent users on the system. Eventually, it would grow to 1000 concurrent users. Is it enough info to determine the type of OS and SQL? Thanks.Diane |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-12-08 : 11:33:57
|
| Start with this: http://msdn.microsoft.com/en-us/library/cc645993.aspx |
|
|
|
ett9300
Starting Member
12 Posts |
Posted - 2011-12-08 : 16:42:51
|
| Thanks Russell. The link is very helpful.We decide to run Windows 2008 R2 64-bit Standard Edition and SQL 2008 R2 64-bit Standard Edition in virtual environment.If you have this type of setup, did you run into any problems with SQL?Thanks.Diane |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-12-08 : 19:51:17
|
| That's a perfectly valid setup.You won't have problems because of those choices, as long as your VMs are properly configured, and the features you need are available in SE. |
|
|
|
|
|
|
How to determine which version to run SQL