remove double post

remove double post

if replication is setup and you add a table to replication by going into the GUI and checking the box next to the article or running sp_addarticle. Once this is...

Hi JK

The joy of archiving data.

I heard you on doing the planning might be a bit of a mission, but if you think determining the order is difficult.

Try to determine...

Hi

I don't have much experience specific to merg replication.

But why don't you increase the retention period.

This will prevent anything from expiring.

Cheers

Jannie

did you check your location of the distrib.exe for any logs.

You can also increase the verbosity of your agent to give more error output.

You can also the the msrepl_errors...

Hi

I wouldn't use SQL policies to monitor for instances being down or not.

Why not SQL policies, put it like this, you are going to monitor an instance different to the...

Hi

No it will not work if no tables are replicated.

Think of replication as a small book publishing company.

In your example the publishers have set up the supply chain to be...

Hi

When you setup the subscription did you click the initialize checkbox ?

You can do it by going on the menu options in replication and goto reinitialize subscription.

Note this will deleted...

if it's only 1 table where an update flag is going to be flipped.

I'd say write a proc that either set the flag to 1 or 0.

Apply proc to you...

Hi

Who is your users?

Can they write SQL?

I'd say dynamic SQL is only required if they know nothing about SQL. Maybe depending on how much they know they can write...

Hi

You should read a bit about the architecture of replication.

I always think of it in 3's

Log reader agent, distribution, snapshot.

If there is nothing in the log for your specfic article...

You have a few options

You can use transactional replication with updateable subscriptions.

You can use peer to peer replication

You can setup bi directional transactional replication , however you will need to...

Hi

Can you give a breakdown of what % of your data is static.

If you are in a position of heaving some beast of hardware based on this,

1 - you mention...

Hi

Good post, I have definately felt like that before.

However I think the problem comes in with people dynamics, in any business the good will progress and the content will be...