Problem in Mirror Removing

• shohelr2003

  Hall of Fame

  Points: 3535

  More actions

  November 29, 2012 at 12:26 am

  #393695

  Dear,

  In mirror database, it shows that myDB (Mirror, Disconnected/ In Recovery).

  I want to delete it or remove mmirroring. But I can't.

  Please help me.

  Regards,

  Akbar

• SQL Show

  SSCertifiable

  Points: 6143

  More actions

  November 29, 2012 at 1:01 am

  #1563586

  Have you properly removed mirroring session before dropping mirrored database.

  http://msdn.microsoft.com/en-us/library/ms190471(v=sql.110).aspx