After you have dropped each database, use sp_dropdevice to drop the failed device. See the Reference Manual for more information.
