What method are...

Carlton B Ramsey (1/11/2011)

---

I would have to agree. I used the attached matrix to help with my selection. Idera, SQLSentry and Oracle rose to the top for the...

My pleasure!

Angelindiego (1/27/2011)

---

....but there's more............

Say I have 20 jobs for replication....do I have to go thru each one manually and add this parameter or is there a quick and dirty script...

Angelindiego (1/27/2011)

---

OK Dave...still digging and scratching here!!

In taking a look at the Distribution database, I see (for the most part) 3 jobs for each publication. REPL_LogReader, REPL_Snapshot and REPL_Distribution....

You can add -subscriptionstreams N in the distribution agent job under the run agent step. Put that in just before the -continuous if you have that in place.

You...

You're welcome. Sorry that I can't answer the initial question more definitively but that is something that you have to come up with a viable solution that will work for...

smarttrail (1/27/2011)

---

may i ask another question. I am not sure if it's foolish ? but is it wise to have a raid mirror db for each of the nodes...

I understand that your connection is dedicated between your webserver and your database server. I'm referring to a layer between your client and your webservers.

smarttrail (1/27/2011)

---

"You have to have the layer that is going to handle this detection and route intelligently"- can you elaborate on this point. exactly how ?

if u remember in sql...

First, you are asking replication to do something that needs to be done via a load balancing solution for the sites, not by SQL Server replication. I can ask the...

Typically for the scenario that is described in that article you would have an internet presence which would do the detection and routing of traffic to the sites that are...

smarttrail (1/27/2011)

---

Yeah may be the failover partner is for database mirroring.- u r right. But i am still looking for - how do i detect a node failure in a...

Yes, as Steve stated that is for Database Mirroring. Is that what you are trying to look into?

Replication would continue to save up the transactions that needed to be replicated to the failed location for the retention period that you specify when configuring replication and distribution. So,...