Replication DR

Question

Replication DR

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
May 4, 2011 at 9:11 pm

#63857

Comments posted to this topic are about the item Replication DR

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Excellent question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736212

May 4, 2011 at 9:29 pm

#1320183

Thanks, I liked this one.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

I like it too. I also like that the R2 doc seems better written on this topic than the SQL 2008 doc

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

One more good question 🙂

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 5

SQLRNNR (5/4/2011)
I like it too. I also like that the R2 doc seems better written on this topic than the SQL 2008 doc

I agree with you! 😀

paul s-306273 SSChampion Points: 10730 More actions · Answer 6

paul s-306273

SSChampion

Points: 10730

May 5, 2011 at 1:56 am

#1320242

Nice question for 3 points.

Thanks Steve.

Chris Houghton SSCrazy Points: 2557 More actions · Answer 7

Thanks Steve. This was a good learning question for me. Replication isn't my strongest area......

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

Nice question, thanks. 3 points w00t!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

M&M SSC-Insane Points: 21700 More actions · Answer 9

Great question Steve.

To be frank, I never thought on these lines.

M&M

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 10

Duncan Pryde

SSCertifiable

Points: 7956

May 5, 2011 at 6:37 am

#1320327

Interesting question, thanks.

mtassin SSC-Insane Points: 23099 More actions · Answer 11

got this one wrong.

Reading the Microsoft Article it seems you could actually configure mirroring on the distribution server, but that it wouldn't work if you failed over.

So technically I think you could do all 3, but as the article states, there's not much point in mirroring the distribution database.

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Trey Staker SSCarpal Tunnel Points: 4796 More actions · Answer 12

Nice question. I learned something new. Thanks. I love these questions that aren't trick questions.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 13

mohammed moinudheen (5/5/2011)
Great question Steve.
To be frank, I never thought on these lines.

Me either, but it makes some sense that you might want to mirror your publications. I think not being able to mirror the distributor is a hole, but perhaps not a huge one.

TomThomson SSC Guru Points: 104773 More actions · Answer 14

Nice question. I like it when the question is clear and the answer too, with no scope for arguing about what it means.

Subscription mirroring isn't all it should be, maybe it will be improved sometime soon? It would be nice to have automatic adjustment or replication when the subscriber fails over.

Tom