How to replicate MS Sql Server to a remote server

Posted on 2009-04-27
Medium Priority
Last Modified: 2012-06-21
What is the proper procedure to replicate MS Sql Server 2008 databases between 2 remote servers.
I have about 12 databases and I need to make exact copy of those at the remote server.
How is this done?
Question by:eugene-g
LVL 57

Accepted Solution

Raja Jegan R earned 2000 total points
ID: 24246450
Hope this helps you out:


Above link explains you well in SQL Server 2005 but it applies to SQL Server 2008 too.

You can do this for all your 12 databases in the same manner.

Author Comment

ID: 24365764
I will test this within a couple of days.

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Loops Section Overview

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question