FIX: Database can't be dropped after its storage is disconnected and reconnected in SQL Server

Applies to: Microsoft SQL Server 2014 Service Pack 2Microsoft SQL Server 2016 Service Pack 1

Symptoms


Assume that you dry to drop (detach) a database from an instance of Microsoft SQL Server. If the database storage had been disconnected and then reconnected, the database is not dropped. Additionally, the client system displays an error message that resembles the following:

Resolution


This fix is included in the following updates:

Cumulative Update 1 for SQL Server 2016 Service Pack 2

Cumulative Update 9 for SQL Server 2016 Service Pack 1

Cumulative Update 12 for SQL Server 2014 Service Pack 2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the standard terminology Microsoft uses to describe software updates.