Hi,

Surely when you apply the snapshot this will synchronise the schemas on Publisher and Subscriber.

Is the table you have modified now consistent on pub and sub ?

Regards

Graeme

Hi,

Sounds to me like your updates have updated a unique constraint on the publisher. When this happens, replication creates two records, a delete and an insert pair. This is not...

Hi Jason,

On the dev box, once you have restored, republish the database as per live (i.e. same publication) then run sp_repldone, then drop the publication. You will then be able...

Hi,

I think this depends on the size of the database and the complexity of your replication.

If you can, it's best to remove replication, make the changes and republish. But this...

Hmmm,

If the table is not too big, I would remove it from the publication, make the structural change and then add it back.

The process might be

Drop subscriptions to the article

Drop...

Hi James,

As far as I'm aware you would just need the procedure sp_addArticle with the publication and article (plus any attributes that are not standard in the publication)

Having added the...

Hi,

Having restored your database I would re-publish it, then run sp_repldone.

This will allow you to clear the log file.

You can then use sp_removedbreplication.

HTH

Graeme

Hi,

I would try to avoid backing up across servers...depending on the size of the database of course.

I done something like this is the past where I backup the db, zip...

Hi,

So Server 1 is currently a publisher and Server 2 is a subscriber...correct.

Once these are in place you can simply republish the data on Server 2 and add the remote...

Hi,

Unless you are making changes at a subscriber, why do you need FKs on your subscriber.

You would definitely need to drop them before re-applying your snapshot.

Graeme

Hmmm...sounds a little confused to me.

Any reason why server 2 cannot be a publisher with two publications.

47 tables in one publication with server 1 as a subscriber

3 tables in one...

Hi,

I think the best way would be to query the tables in the Distribution database.

MSArticles contains all tables used in all the publishers on that server, you can join in...

Hi,

By querying the MSreplication tables in the distribution can you determine what commands are waiting to be applied by the agent?

Graeme

Hi,

Seeing as you are using a Pull subscription have you checked the distribution agent at the Subscriber as I assume that is where it will run.

You noted that the agent...

Not sure..probably not...but that is the default setting

Can I ask why you do the following

update distribution..MSsubscriptions set status = 2

Thanks

Graeme