Show TOC

sysadmin dropldbLocate this document in the navigation structure

Drops a logical database from the ID Server.

Syntax
sysadmin dropldb, <data_server>, <database>
Parameters
data_server

The name of the logical data server.

database

The name of the logical database you want to drop.

Examples
Example 1

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

sysadmin dropldb, LDS, pubs2
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.

Caution

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

Permissions

sysadmin dropldb requires “sa” permission.