What is Windows Server 2008 edition for DB Server
We are maintaining our servers and we will have 3 servers - 1 db server and 2 external web servers. For web servers we will be using 2008 Web version, but we cannot decide which version to use for db.
At first we thought about using the Standard edition, but with our host it runs 10x more per month than the web edition. Our third option is to use the Data Center edition, which costs 5x more than the web edition.
Can we and should we run SQL 2008 on a Windows Server web server? If not which edition should we choose?
Thank.
source to share
The minimum requirements for all versions of SQL 2008 are here .
Server 2008 Web is listed as a supported OS, so you should be fine.
EDIT: I should clarify that it is possible to run SQL 2008 on a Windows Server webserver, but I'm not sure what the limitations are. The Web server has more restrictions than the server standard, but I'm not sure what it is, whether it be hardware or something.
source to share