Show TOC

sysadmin dropdbLocate this document in the navigation structure

Drops a database from the ID Server.

sysadmin dropdb, <data_server>, <database>

The name of the data server.


The name of the database you want to drop.

Example 1

Drops the <pubs2> database in the SYDNEY_DS data server from the ID Server:

sysadmin dropdb, SYDNEY_DS, pubs2
  • Use sysadmin dropdb to drop a database from the ID Server. This command must be executed at an ID Server.

  • Use sysadmin dropdb only when the ID Server system tables contain information about a database that does not exist in the system. This should happen only after a system failure.

    For example, if a database is dropped with drop connection, a network failure might prevent the ID Server from being notified so that it can remove the database from its tables. If you attempt to add the same data server and database to the system later, the request will fail because the database and its data server are already registered in the ID Server system tables.

  • If you reinstall a Replication Server, use sysadmin dropdb to remove the ID Server information for each database the Replication Server managed, including its RSSD. Otherwise, errors occur when you reinstall Replication Server.

  • If you enter invalid arguments with this command, you are not notified.


Never use sysadmin dropdb on any databases that have active connections.


sysadmin dropdb requires “sa” permission.