Sql-server – How to set up replication on SQL Server 2008

backupdatabasereplicationsql server

Say you have a production database and a staging database that you want to have replicate on a semi-hourly basis across the internet. The general intent is to have a stand-by backup, but also to have second read-only database for testing.

How would you go about setting that up and configuring it?

Any notes about performance implications are a plus.

(Answers regarding SQL SERVER 2005 or 2000 also welcome)

Best Answer

You'll want to take a look at log shipping. While the following article is a few years old, it walks you through the why's and hows:


The SQL Books Online covers it here: http://technet.microsoft.com/en-us/library/bb895393.aspx

Related Topic