JoshDBGuy (12/30/2013)
and need to replicate/mirror/copy/log ship to another server in the cloud.
First thing to do is to decide on which you will use sounds like you have thought about it at length which is good.
JoshDBGuy (12/30/2013)
The original plan was to use log-shipping but there are some limitations and other factors that drove me away from this.
Such as?
Why did you feel that LS was not a viable route?
JoshDBGuy (12/30/2013)
- I would like this to have as little maintenance as possible so that we don't need another full-time person monitoring the process. I'd prefer to not have this take up 75% of my day
Ok, know this from the start. Replication is good but there is a possibilty of high maintenance and all for the reasons you have already queried.
JoshDBGuy (12/30/2013)
- How difficult is it to maintain replication versus log-shipping or mirroring?
IMHO, mirroring and log shipping are far easier to maintain than replication. Mirroring and log shipping ship the whole database whereas replication is done at an object level.
As I have already said, "why did you feel that mirroring or log shipping were not suitable?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉