Unanswered: Help removing a database that is on a device that does not exist.
Here is my problem:
We have a database (with no data) that is on a device for which there is no disk.
If I try to drop the database, I get the following error: Number (840) Severity(17) State(1) Device 'xyz' (with physical name '/dev/rdsk/c1t1d0s0', and virtual device number 15) has not been correctly activated at startup. Please contact a user with SA role..
I can understand this since we don't have a disk for this device afterall.
If I try to dbcc DBREPAIR, I am told the following: Number (2573) Severity (16) State (1) Database 'xyz' is not marked suspect. You cannot drop it with DBCC.
If I try to drop the device, I am told I cannot drop it since I have a database that is using it.
So how do I get rid of this database and device from my system?