Thank you very much Perry. It caused me a lot of confusion and it was eating my head for a long time.. No documentation provide better explanation. Everyone is providing...

Hi,

One follow up question out of curiosity. If I have transactional replication with remote distributor (say) and database mirroring for publisher database in High safety mode(i.e. automatic failover), then how...

Thank you very much Lempster and Perry.

Hi SQLBuddy,

Thanks so much.

Yes. I have provided the unc path. no luck.

Hi LightVader,

Thanks for the answer for scenario-1. I got to know the same thing from my peers. We need to break the mirroring and bring it online.

use master

go

alter...

Hi Perry,

I have tested the scenarios on my personal laptop. I have created 3 sql instances and setup mirroring. All are sql 2008 developer edition , service pack 3.

Thank you Paul and Jimbo.

Thank you Perry.

Got it. Thank you very much Gail.

Any comments on questions 1 & 3? I think I have asked the repeated question. I was reading the database mirroring yesterday and...

Thank you very much George. 🙂

Thank you for the help.

Hi George,

Thanks for the response. Could you explain why I need to pick up Distributor first and why not subscriber or publication?

Hi Grant,

Thanks for that cool stuff. It would be a great help for any starter and want to dig deep dive.

I also thank Gail, Lowell for putting up all...

Thank you much for the help.