INF: SQL Administrator Drop Command Drops Databases (87510)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q87510 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.
| Modification Type: | Major | Last Reviewed: | 3/16/1999 |
|---|
| Keywords: | KB87510 |
|---|
|