sysadmin dropldb

Drops a logical database from the ID Server.

Syntax

sysadmin dropldb, data_server, database

Parameters

Examples

Usage

  • Use sysadmin dropldb to drop a logical database from the ID Server. This command must be executed at an ID Server.

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

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

  • If you reinstall a Replication Server, first use sysadmin dropldb to remove the ID Server information for each logical database the Replication Server managed. Otherwise, errors occur when you reinstall Replication Server.

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

Warning!  Never use sysadmin dropldb on any logical databases that have active connections.

Permissions

sysadmin dropldb requires “sa” permission.

Related reference
sysadmin dropdb