Viewing 15 posts - 451 through 465 (of 1,790 total)
Pei Zhu-415513 (12/20/2010)
If the database is simple/or bulk logged database, will the minimally logged activities such as rebuild indexes be replicated to subscribers?
Those activities are not replicated. It would be...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 20, 2010 at 9:31 am
Elliott Whitlow (12/17/2010)
Are the database files pre-sized? If not then it will spend a lot of time...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 2:58 pm
If it is busy and you have memory limitations already then that would certainly impact things. Do you know how long the copy process is taking vs the applying of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 2:56 pm
Would Change Data Capture work? Curious.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 1:56 pm
Jack Corbett (12/17/2010)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 1:22 pm
Couldn't you just query their data and pull the most recent record prior to the event you are interested in?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 12:53 pm
Oh, you would run that query on the distribution database on the distributor. You would also find the job there.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 12:38 pm
ron morgan (12/17/2010)
Message
Error: 14151, Severity: 18, State: 1.
Message
Replication-Replication Distribution Subsystem: agent (null) failed. The publication 'Temp_Report_Requirements_DM01' does not exist.
It looks like you have a distribution agent that is running against...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 12:36 pm
As Andy already mentioned, missing indexes in the graphical plan is a huge plus. They are usually pretty accurate or pretty close making it pretty helpful.
I will have to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 7:16 am
Unfortunately no I don't. Merge replication is by nature more expensive than other types of replication. Still viable is using transactional with updateable subscriptions. That however doesn't allow for the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 6:31 am
Yeah, I will have to play with it a bit more as well. Also want to play with a tally table version to see what it does.
One other thing...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 17, 2010 at 6:14 am
sharad-1144828 (12/16/2010)
I have 3 servers and want to apply merge replication for this as A to B to C to A.
Can some one please guide me how to implement...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 16, 2010 at 12:05 pm
Great! If you have time reply back with what you find helpful as it may be good information for the future.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 16, 2010 at 8:31 am
Hey Jeff - I certainly like that function better than most that I have seen and used. One question I do have though; have you noticed that it always seems...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 16, 2010 at 7:48 am
If you do have a tape backup you can still take a log backup and do a point in time restore. Again, all hinging on the full backup existing.
Honestly...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 15, 2010 at 11:28 am
Viewing 15 posts - 451 through 465 (of 1,790 total)