Hi,

Is this a big table ?

Can it be removed from the publication, altered and then put back in ??

Regards

Graeme

Why don't you query sysindexes ?

Hi,

If you wan't to view the indexes on a table then one way is to goto EM right click on the table and Manage Indexes

Graeme

Hi,

There are lost of ways to do this.

This will depend on table size/usage etc.

Initially you could try..

Set up a linked server on your Test Server B looking at Production Server...

Hi,

Am I right in assuming you are trying to republish a merge subscriber as a Merge publisher ?

Graeme

Hi,

Are you backing it up ?

Are you running the Distribution Cleanup jobs that are created when you create the Distribution database ?

Regards

Graeme

Hi,

How big are your replicated databases ?

Do have all the indexes in place, particularly on the rowGuid column?

Graeme

Hi,

That sounds interesting.

I'm surprised 1000 users is giving you a problem.

Certainly a central database subscribers at various sites is a viable solution.

I assume you would want all the changes...

Hi,

So have you removed replication totally from server 1 before putting it back on server 2 ?

Can you give me the steps you went through..... 🙂

Thanks

Graeme

It's not the comma at the end of the declared variables is it ?

Regards

Graeme

Hi,

Have you tried having the Distributor on the publisher ??

Regards

Graeme

Hi David,

Yeah that sounds good.

We are upgrading to 2008 next month...but ours will be inplace.

I can let you know any problems we have.

Graeme

Hi,

I agree with that.

I guess the thing you need to remember is that merge replication is designed so that if the subscriber goes offline, data entry can still happen at...

Hi David,

Nothing too involved actually.

We wanted to move the log file of our merge publisher database...without dropping all the merge.

We went for the option of backing up and restoring over...

Hi,

I suggest....more information please

Thanks

Graeme