If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Help removing a database that is on a device that does not exist.

Hi,

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.