Andrew,

Is there anyway you can help me out in figuring how this read only routing is made. As far as my knowledge goes, client connections connect to listener and from...

Thanks Andrew. What i am looking for is how to balnce these read only connections between one read write, two read only nodes. all the writes will be hitting the...

there's no cpu or memory contention. We increased the max workers thread from 2000 to 4000.But we are still seeing issue. Suddently the worker thread count reaches the max value...

the problem is sql server not responding for a minute or two and then recovers. There's no blocking or deadlock schedulers. In a fraction of second it's getting recovered. It...

yes. We are using sqlsentry.

SAN...

S_Kumar_S (12/31/2013)

---

for the benefit of those who fall across this thread, here is I solved this:

I created a proc on main server which was schedule and it will delete the...

for DR purpose.

David,

I was testing the synchronous mirror method. Automatic failover works fine as soon as the principal goes down but the tricky part is how to make the mirror act as...

Thanks David. I am able to resolve that issue.

But here the problem is if we have a backup of distributor around 4 A.M in the morning and the server...

Jimbo,

so in this case even if we have a backups of distribution server we will be not able to use them when a server crashes. Is there any high availability...

Jimbo,

I tested it by restoring the master,msdb and distribution databases. But i am facing problems with log reader agent throwing following errors--

The process could not execute 'sp_repldone/sp_replcounters' on 'MyPublisherServer'

The specified...

MysteryJimbo (11/25/2013)

---

I should have been clearer. You continue to stand...

MysteryJimbo (11/25/2013)

---

Are there any distribution db backups? If so there is an MS article on how to restore it.

Will the data have changed on the published databases? If not,...

what do you mean by distribution database fails? what's the reason behind it?