Solved

SQL Server 2008 Replication?

Posted on 2011-09-07
3
227 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 40

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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach 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.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

752 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