Removing mirroring

• Ziljan4

  Ten Centuries

  Points: 1136

  More actions

  April 2, 2008 at 12:26 am

  #188640

  can we remove database mirroring using SQL scripts.? If yes could someone please provide me the script to break the DB mirroing between Server A and Server B.

  Thanks in advance.

• julia.nicholas

  SSChasing Mays

  Points: 602

  More actions

  April 2, 2008 at 3:21 am

  #797060

  ALTER DATABASE yourDBName SET PARTNER OFF

  will break the mirror. You can run this command on either the ServerA or ServerB (Principal or Mirror).

  You'll then be left with the Mirror database in recovery mode so if you want to bring this back online use:

  RESTORE DATABASE yourDBName WITH RECOVERY

  Hope that helps.

  Julia