Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Operating mode change in mirrroring Expand / Collapse
Author
Message
Posted Monday, December 03, 2012 2:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:55 AM
Points: 175, Visits: 470
I configured mirroring with High safety with automatic failover (synchronous) option.

Now I want to change my operating mode to High Performance (Asynchronous) but getting all options disabled.

How can I change it? Please help me.

Regards,
Akbar
Post #1391812
Posted Monday, December 03, 2012 2:35 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
High performance mode is available only in Enterprise edition.

Run this command in principal.
Alter database dbname set partner safety Off
Post #1391816
Posted Monday, December 03, 2012 5:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 5,958, Visits: 12,839
shohelr2003 (12/3/2012)
I configured mirroring with High safety with automatic failover (synchronous) option.

Now I want to change my operating mode to High Performance (Asynchronous) but getting all options disabled.

How can I change it? Please help me.

Regards,
Akbar

as already mentioned high performance is only available in enterprise edition, which edition is your instance running?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1391858
Posted Monday, December 03, 2012 11:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:55 AM
Points: 175, Visits: 470
standard edition
Post #1392257
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse