solidDB Help : Replication : Advanced Replication : Maintaining a distributed system : Unregistering a replica database
  
Unregistering a replica database
When a replica database is not used in an Advanced Replication system, it is strongly recommended that it is unregistered (that the synchronization relationship between the replica and master databases is removed). After unregistering the replica database, the master database no longer saves synchronization history data for this replica database. This might save a significant amount of disk space in the master database.
To unregister a replica database, complete the following steps:
1 If data is no longer needed in the replica database, drop the subscriptions in the replica database.
2 In the replica database, execute the following statements to unregister the replica with the master database:
MESSAGE message_name BEGIN;
MESSAGE message_name APPEND UNREGISTER REPLICA;
MESSAGE message_name END;
COMMIT WORK;
3 Send the message to the master database.
MESSAGE message_name FORWARD TIMEOUT seconds;
COMMIT WORK;
The replica database can no longer synchronize with the master database.
A replica database can also be dropped from the master database by using the DROP REPLICA statement in the master database. If you drop the replica by using the DROP REPLICA statement, you should also drop the master from the replica with the DROP MASTER statement. This method might be necessary if access to the master database needs to be denied from the replica database or the replica database cannot unregister itself. For more information, see DROP REPLICA and DROP MASTER.
Go up to
Maintaining a distributed system