Solved

SQL Server 2008 Replication?

Posted on 2011-09-07
3
225 Views
Last Modified: 2012-05-12
Greetings,

We have a group that has opted to have a SQL Server db server replicated to a SQL Server db server in a cloud host. The problem we have with this is that the local source server has to connect to the target db server via cloud host vpn. Is this a bad idea? Also this group is using merge replication. The db server being hosted in the cloud host serves as a standby server that they light use as well. Should they use log shipping or some sort of transactional replication instead of merge replication? Please advise.
0
Comment
Question by:Omega002
3 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 250 total points
ID: 36502998
Merge replication is used when you want transactions hat take place on either server to be replicated to the other. I can't tell from your question, but when people use the replicated server for "light use", will they be making changes or just running read-only reports? If they'll be making changes, Merge replication makes sense, but if it's just read-only, then something like transactional replication would be more appropriate.

I prefer transactional replication, but it requires that a normal SQL connection can be opened, which it sounds like it can. If you can't (or don't want to) open a regular SQL connection, then you can use log shipping to send the logs via FTP or some other method, and then they're applied at the destination.

To answer directly, I don't think running the replication over a VPN to the cloud host is a bad idea - it's probably the safest way to get your data there.
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 250 total points
ID: 36505820
I agree with ryanmccauley and I would definitely use anything else but Merge replication for a  StandBy SQL server on the cloud.

http://msdn.microsoft.com/en-us/library/ms178034.aspx
0
 

Author Comment

by:Omega002
ID: 36506195
You guys provided excellent insight on my questions. Thanks
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Solution for warm standby SQL server 20 49
Sql query 107 60
Anyway to make these 2 SQL statements into one? 13 38
How can i use WITH CTE for checking exist value? 3 30
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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