Database Mirroring

Database Mirroring adjusting the automatic failover time

  • Article

One of the configuration options for Database Mirroring is the High Availability mode. With this option three servers are put in place the principal, mirror and witness servers. This is the only option that allows for automatic failover. One of the things that I have noticed is that when there are periodic network issues a failover occurs even though there are no issues with the Principal server. Are there any options to delay the failover?

2008-10-29

3,626 reads

Blogs

Covid Thoughts, So Far

By

I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Read the latest Blogs

Forums

Why would I want to use Compress and Decompress functions?

By VoldemarG

in what live operational or development situation /requirement would I want to use the...

Updating data with recording old values - thought process

By ucltech

Client has a projections table that sales reps can update on their own.  They...

Replacing / Removing All Text In Multiple Sets of Characters in SQL

By mnovosel

One of the result fields has multiple html references in it such as in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers