Viewing 15 posts - 391 through 405 (of 1,790 total)
michael.morse (1/28/2011)
A view is not going to accomplish what is being requested.So there isnt a way to customize the replication trigger to accomodate for the different field order?
What method are...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 28, 2011 at 1:53 pm
Carlton B Ramsey (1/11/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 28, 2011 at 8:06 am
My pleasure!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 3:27 pm
Angelindiego (1/27/2011)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 3:15 pm
Angelindiego (1/27/2011)
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 3:13 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 12:25 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 10:02 am
smarttrail (1/27/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 9:50 am
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 9:24 am
smarttrail (1/27/2011)
if u remember in sql...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 8:53 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 8:06 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 7:33 am
smarttrail (1/27/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 6:59 am
Yes, as Steve stated that is for Database Mirroring. Is that what you are trying to look into?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 6:51 am
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,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 27, 2011 at 6:37 am
Viewing 15 posts - 391 through 405 (of 1,790 total)