How do you remove a mirrored database SQL Server 2012 I have mirrored databases (synchronized), how do I delete such a database correctly? I tried

use master
alter database test0224aEd62 set single_user with rollback immediate
drop database test0224aEd62


by get error


  Msg 1468, Level 16, State 1, Line 2 The operation cannot be performed
  on database "test0224aEd62" because it is involved in a database
  mirroring session or an availability group. Some operations are not
  allowed on a database that is participating in a database mirroring
  session or in an availability group. Msg 5069, Level 16, State 1, Line
  2 ALTER DATABASE statement failed. Msg 3752, Level 16, State 1, Line 3
  The database 'test0224aEd62' is currently joined to an availability
  group.  Before you can drop the database, you need to remove it from
  the availatility group.
The operation cannot be performed on database "test0224aEd62" because it is involved in a database mirroring session or an availability group. 


The error is self explanatory .. you cannot drop a database if it is part of DB mirroring, AlwaysON or replication.

I normally avoid using GUI when I have option of doing same thing using TSQL ...

For future readers, you can break database mirroring using below TSQL command (run it on the secondary server)

ALTER DATABASE &lt;&lt;DB NAME&gt;&gt; SET PARTNER OFF


Once mirroring is broken, then you can drop that database using 

alter database &lt;&lt;db name&gt;&gt; set single_user with rollback immediate
go
drop database &lt;&lt;db name&gt;&gt;
go