Reducing failover time

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.