Two replicas are from different replica sets and cannot be synchro

[Guest]

I have a master database with two replicas, but the master lost the fact that
it was a master and i was unable to synchronise.

I created a new database and imported from the master and made the new
database the master, and i can create replicas etc. but now i cant
synchronise with my original replicas. I get this error: The two replicas are
from different replica sets and cannot be synchronised.

I know why this error is occurring but is there a way around it?

The database is Access 2000.

Thanks

 

[Luiz Cláudio C. V. Rocha [MVP]]

Taken from ReplFaq2k:

44.1.How do I recover a lost or corrupted Design Master?
Synchronize all of the replicas in your replica set to make sure that all
existing members are up to date. Then choose one of them to be the new
Design Master. You can make it the Design Master either from the Replication
menus, the Replication Manager, or from code by setting the DesignMasterID
property.


Luiz Cláudio C. V. Rocha
São Paulo - Brazil

 

[Guest]

Thanks Luiz, but my problem is that i cant synchronise ... /

Kieran

 

[Luiz Cláudio C. V. Rocha [MVP]]

Can't you synchronize Replica A with replica B? Did you create a tree
topology?

Luiz

 

[Guest]

Thanks. Im not sure what you mean about a tree topology.

We have three locations. My location has the design master. The other two
locations have replicas. Each put in their own data, which is weekly
synchronised.

I didnt try synchronising the two remote locations' databases. Even if this
works, i need to be able to synchronise with the design master, which is at
my location.

Hope this makes sense!

Kieran

 

[Luiz Cláudio C. V. Rocha [MVP]]

Hi Kieran,

you can sinchronize Replica A directly with Replica B, and then convert one
of them to be the new design-master (menu Tools > Replica > Recover
design-master).

Luiz Cláudio C. V. Rocha
São Paulo - Brazil

 

[Guest]

Hi Luiz,

I can probably sync replicas A and B, but what about my master M - it has
data that A & B need to get and vice versa ..

Thanks

Kieran

 

[Luiz Cláudio C. V. Rocha [MVP]]

I'm reading again your original post. Your original master was not lost or
corrupted, right? Instead of creating a new database and importing the
objects, did you try Tools > replication > Recover design master?

How did it "lost the fact that it was a master"? Any error message?

Do you hava all your data in Rep-A and Rep-B, or your old Master-M has some
extra data?

Luiz Cláudio

 

[Guest]

Thanks Luiz. I dont know how it lost its master status. I went to synchronise
one day, and the option was unavailable.

I will have to go back to a backup to see if i can recover the design
master. When i realised it list its master status, i tried to create a
replica and i got the error "Microsoft Access can't convert the database to a
Design Master. Cannot make the BuildingType object in Tables container
replicable". I made no changes to tables or database structure, so i cant
understand how this happened. The only way i was able to get around it was to
create the blank database and import etc.

My Master M database has some data that the replicas dont have, so i need to
have it synchronising. Failing all this, i wonder if theres any way i can
'fool' access into thinking that the master is in the same replica set as the
replicas. I thought i might be able to manually update the mSysReplicas
table, but i've no access (

Thanks for all your patience and suggestions!

Regards

Kieran

 

[Luiz Cláudio C. V. Rocha [MVP]]

Hi Kieran,

I don't believe it's possible to include an external DB to an existing
replica set.

You can try the following:
a) Synchronize Rep-A and Rep-B;
b) Create a new Design Master from Rep-A;
c) Import data from your old design master.

How? ==> http://support.microsoft.com/?kbid=208323

Luiz Cláudio C. V. Rocha
São Paulo - Brazil

 

[Guest]

Thanks Luiz, you are a star !!

I did what you suggested, but first i had to make my 'Master' M database a
regular database (http://support.microsoft.com/?kbid=208394).

I then followed the instructions in 'How to recover data from a nonmember of
a replica set' and it worked perfectly!

Thanks once again for all your help and patience.

Best regards

Kieran