Thanks for the reply Brendan. Mirroring is not an option "for this case" because the database on site 2 needs to be available for read. Mirroring is still an...

If replication is completely off the table for your plan, what do you suggest instead to remedy the solution described in the previous response to maintain business continuity? The thing...

Brandie Tarvin (1/27/2012)

---

SQLKnowItAll (1/27/2012)

---

If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending on...

I guess what I am trying to make clear is that this is not a complete solution, but one piece of a much larger comprehensive plan. Of course, I wuold...

Hi Brandie,

Although I agree with you from a DBA perspective, I would disagree that this is not an acceptable DR solution from an application standpoint. The reasons you cite don't...

I just did a quick "click" on replication to create a new publisher and went through a bit of the process to see that peer-to-peer is not an option....

Well, since I am reading the 70-432 training kit... I will look it up! 🙂 I suppose I was taught the ways in which things are done at the company...

george sibbald (1/27/2012)

---

Jared,

Reading Pauls article what immediately jumps out to me is arguments 5 and 6 and perhaps 8 are pretty good reasons for not going with replication as a...

Ian Scarlett (1/27/2012)

---

That is a nice article from Paul.

From your requirements, there is one thing that would still bother me about using transactional replication...

Argument 8: There's no easy way...

Hi Chrissy,

It sounds like you have a lot of experience, so I don't want to dwell on this... but in the long term, as your data grows, formatting before SSRS...

Ahh... Good to know Paul Randal makes the same arguments I do 🙂

Now that you have your answer, Chrissy, can I ask why you are worrying about this formatting in SQL? Maybe there is a better way to handle the formatting on...

I'm sorry that this was not in my original description, but it...

Maybe I...

Ian Scarlett (1/26/2012)

---

How would you revert to the original server once it's back up and running?

You would have data in the backup server that has no obvious way of getting...