At our company we currently run one windows 2008 server. It has the following roles installed:
active directory domain services
dhcp server
dns server
file services
From our users point of view, we log into the domain from our workstations and have some folders we use for file sharing. We also use this box to serve a very old foxpro database ERP program. This is everything that I'm aware of that this machine does. We are updating to a new ERP program that will use MS SQL 2008 R2. In the process we've gotten a more powerful windows server 2008 r2 box. We went from an older dual core xeon and 2 GB of ram to a nice quad core with 8 GB of ram. My question is this, what is the ideal way to have our servers setup? We do still need to have access to the old foxpro database and program on the old server.
Should I just transition all of these roles to the new machine and then use the old machine just to host the foxpro erp program?
Or should I just join the new machine to our domain and load it up with MSSQL and soley use it for the new ERP software?
Or perhaps some mixture of the two, where I maybe just do ERP and file sharing on the new one?
I know this is going to depend a bit on the resource requirements ERP software, but the minimum specs for this software are even somewhat below what our old server has. From what I understand, the new server is overkill because we're only really looking at maybe an average of 4 transactions per second, probably lower. I think they just wanted a new server because they didn't want to have the old serving running both ERP programs, so they just picked out a new server that was around the same price they paid for the older one several years ago. You might consider in your advice (which I really appreciate!) that easier could be better, because I have very limited knowledge of windows server. I used to administrate some unix and novell servers years ago, but I've since changed my skillset and was recently given this task to complete, which I will do. I have a feeling that we have more hardware power than we need, so a smooth transition might be more important than squeezing every last drop of performance out of these servers.
Thank you very much for your help!