none
Mirroring configuration RRS feed

  • Question

  • Hello,

    I need your support as i have database environment exists in Main site and configured the mirror database to be exists in DR site.

    i configured the witness to be exist on the DR site

    the issue now when the network line down, the database move to the other site automatically.

    i increased the timeout configuration to be 30 minutes as per below command:

    ALTER DATABASE ProdDB SET PARTNER TIMEOUT 1800

    and the network line down for 2 minutes only but my database moved automatically to the other site.

    how can i disable this automatic failover or delay it or configure number of retries for certain time of period then move the database to the other site.

    appreciate your support .

    Regards

    Mohamed

    Monday, July 29, 2019 9:46 AM

All replies