Hi All,
Is it possible to reduce the automatic failover time on MS SQL 2005? It seems to take around a minute on my servers.
Thanks for your help.
Regards,
1 Minute?, is so much time, can you post your configurations pls?...
John Bocachica
|||Failover time can depend on a lot of things.
Refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx for a discussion on what happens during the automatic failover.
What type of failure are you talking about here?
What is load on the database? Take a look at the redo_queue on the mirror at the time of failure.
More details needed to answer your question.
