I am looking to see how I can best split up a server. I have one server with a SQL Server database. I want to take the load off the one server and "replicate" the entire database to a second server. The second server will be used primarily for reports and special query's. The other server will be used for new orders (Order Entry system). If I split the workload between two servers...I am hoping to reduce the bottleneck problems. Is there a third party software program that can replicate data between the two servers? Sort of like syncing the data all the time? Thanks for any help.