Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We need a new install of windows server and sql server to replicate a couple of databases to a geographically separate location from an existing application (over a site-to-site VPN). The source database is SQL Server 2005.

However, this is a temporary solution since the client is aiming to implement a different system entirely, so we are looking to find the minimum specification of both windows server and sql server to do this.

We are finding the SQL server features per edition and licensing a little difficult to understand, hence the question. Am I correct in thinking that we can replicate data using transactional replication from SQL Server 2005 to 2008 web edition and we can install sql server web edition on windows 2008 web edition also?


share|improve this question
up vote 3 down vote accepted

SQL Server 2008 Web edition supports replication as a subscriber and SQL web edition can be installed on Windows Server 2008 Web edition. Only SQL datacenter, enterprise, and standard edition can act as a publisher. You might also want to note that Web edition is not free and only a per processor licensing. SQL Server 2008 Express edition supports replication and is free, but has a 10GB database size limitation.


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.