Microsoft KB Archive/87510

= INF: SQL Administrator Drop Command Drops Databases =

Article ID: 87510

Article Last Modified on 3/16/1999

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



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 (&quot;Drop...&quot;).



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.

Additional query words: SQL Admin

Keywords: KB87510

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.