I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So ...

How to Synchronize Two Microsoft SQL Databases. If your business uses Microsoft SQL Server, you may want to have multiple instances of servers on multiple computers for synchronization or backup ...