Drop a Database from the ID Server

Use sysadmin dropdb to drop a database from the ID Server.

Replication system databases, data servers, and Replication Servers are listed in the rs_idnames system table in the RSSD for the ID Server. Occasionally, you may need to remove the entry for a database from this system table.

For example, the drop connection command fails and you want to reuse the connection name. You must force the ID Server to delete from the rs_idnames system table the row that corresponds to the database. (Physical database connections have a “P” in the ltype column in this system table.)

Log in to the ID Server and execute the sysadmin dropdb command to delete the entry for the specified database. The syntax for sysadmin dropdb is:

sysadmin dropdb, data_server, database

You must have sa permission to execute any sysadmin command.