BES Database failover
Posted on 2011-05-02
Running BES 4.1.7 with SQL 2005 for a database. We have about 10 BES servers. The SQL database (SQL1) also has a replication partner, SQL2.
The SQL team want to test the fail over of services from SQL1 to SQL2.
Theoritically, there should not be any downtime for BES.
There are still some queries I had though -
1. When the database is failed over, how can I check that BES is still running as usual? What sort of tests would be good (apart from the Test SQL connection one)
2. If - for whatever reason, the SQL team said that the fail over would result in 2 hour outage. What would be best? Leave BES server running, but queueing messages, or just shut them down?