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:
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.