Dropping private devices using sp_dropdevice

Use sp_dropdevice to drop a private device. You can execute this procedure from any instance in the cluster. However, it fails to drop a private device if the owning instance is not running. For details about using sp_dropdevice, see the Reference Manual: Procedures.