locked
High Availability to High Protection without reconfiguring Mirroring RRS feed

  • Question

  • Hi,

    Is there a way to configure mirroring to go from High Availability to High Protection without having to reconfigure Database Mirroring? Using the interface in Management Studio, I can change the configuration option to High Performance, but not High Protection despite both of them being Synchronous.

    If not, what are the recommended steps to configure the mirror once it already has been configured? Is just like initially setting up the mirror or would there be any shortcuts I could take? If I stop the mirroring and remove the witness, will the High Protection option be available?

    Thanks,
    J.
    Monday, April 23, 2007 8:32 PM

Answers

  • Hi Jchohio,

     

    When you are in high availability mode you the witness server is configured SAFETY FULL. To switch to High-Prottection mode, just turn the witness server by using the following command.

     

    Code Snippet

    ALTER DATABASE <database_name> SET WITNESS OFF

     

    where <database_name>  is the name of the mirrored database.

     

    regards,

     

    Jag

    Monday, April 23, 2007 9:50 PM

All replies

  • Hi Jchohio,

     

    When you are in high availability mode you the witness server is configured SAFETY FULL. To switch to High-Prottection mode, just turn the witness server by using the following command.

     

    Code Snippet

    ALTER DATABASE <database_name> SET WITNESS OFF

     

    where <database_name>  is the name of the mirrored database.

     

    regards,

     

    Jag

    Monday, April 23, 2007 9:50 PM
  • Thanks for the Reply!
    -J.
    Tuesday, April 24, 2007 4:12 PM