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...
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...
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...
December 17, 2010 at 2:56 pm
Jack Corbett (12/17/2010)
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?
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.
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...
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...
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...
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...
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...
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.
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...
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...
December 15, 2010 at 11:28 am
Viewing 15 posts - 451 through 465 (of 1,790 total)