I'm running SQL Server 2012 in a mirror configuration and I need to move the mirror's transaction files.
I deleted the mirror setup on the primary but I can't detach the databases on the mirror, the option is grayed out.
I used activity monitor and the database files are NOT being used so I should be able to detach the databases. Does anybody have any clues as to what the hold up is?
Thank you.