Skip to Content
0
Former Member
Jun 14, 2014 at 05:19 AM

Dropping device without prior dropping database

1178 Views

Hi there,

Is there anyway to remove a device without removing database as the database still in use. thanks in advance.

1> sp_dropdevice QA1_data05

2> go

Msg 17482, Level 16, State 1:

Server 'QA1, Procedure 'sp_dropdevice', Line 110:

Device is being used by a database. You can't drop it.

database_name device size

----------------------- --------------------- ----------------------------

QA1 QA1_data05 10240 MB

Regards,

AM