0

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.

  • 2
    And how you deleted mirror configuration ?. I am sure you did it in wrong way – Shanky Aug 27 '15 at 10:00
  • I opened SQL Management Studio on primary, tasks -> Mirror, choose "delete Mirror". What would you suggest? – Tensigh Aug 27 '15 at 14:04
1

To remove database mirroring

  1. Connect to the Database Engine of either mirroring partner.

  2. From the Standard bar, click New Query.

  3. Issue the following Transact-SQL statement:

ALTER DATABASE database_name SET PARTNER OFF

where database_name is the mirrored database whose session you want to remove.

The following example removes database mirroring from the AdventureWorks2012 sample database.

ALTER DATABASE AdventureWorks2012 SET PARTNER OFF;
|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.