INF: SQL Administrator Drop Command Drops Databases

  - Microsoft SQL Server version 4.2

SUMMARY

In the Microsoft SQL Administrator Device Management window, if you choose Devices from the Manage menu, and then choose Drop, a dialog box appears asking if you really want to drop the device. If you choose the Yes button, SQL Server not only drops the device, but also any database(s) residing on that device. There is no explicit warning that the database(s) will be dropped.

If the device is a dump device, SQL Server drops it immediately without the additional dialog box implied by the ellipses after the Drop command on the Manage menu ("Drop...").

MORE INFORMATION

You cannot drop a device on which a database resides. In order to carry out your request to drop the requested device, SQL Administrator drops all databases residing on that device.

This behavior is by design in Microsoft SQL Administrator 4.2. Microsoft is considering an enhancement to add a message explicitly stating that all databases residing on the device will be dropped.

NOTE: The current version of SQL Administrator displays a list of databases and asks you to confirm.