we have a single windows 2003 server running SQL server. we are currently using gmail for our network users to individually administer (and backup) their email.
we are looking to upgrade our server now, and I understand that it is not recommend to run SQL server on the same server as exchange.
this is only a relatively small network with around 10 users, and we would like to have control over our own mail server.
is it possible to have SQL server running on a stand alone workstation, rather than on our server? if this would be possible, we could then install sbs2011 and have SQL server on our network?
if the answer is yes, how would this impact performance and things like backing up the SQL server.
would you recommend against it, or do you have any other suggestions.
we would ideally like to have exchange and SQL server running on the same server, as we don't want to have to fund a second server for SQL, but we like the idea of having everything centrally located for administration and backup purposes.
your comnents and advice would be much appreciated,