[phelaja]

Hi

I've got a query I was hoping someone could help with......

I've got 2 BES 5.0 server on a win2k3 server, which includes a local install of SQL2005 for the BES Config database. The BES database is setup for Mirroring. The BES servers are configured for manual failover.

In the registry under BES the 'database' key lists 'DatabaseServerMachineName' and 'FailoverServerMachineName'.............

My questions are, (and I don't have a test environment to try\test this);
1) If I initiate a manual failover in BAS will the database also be failed over from 'Principle' to 'Mirror'?
2) If I do a SQL Mirror failover, I imagine I'll have to manually update the BES 'database' registry key to account for my swap?

hope someone can help

thanks
P

[besadmin23]

Answer for 1 is NO. Failover of BAS nodes is not dependant nor related to SQL DB principle or mirror failover status...

Not certain about the second however, and I know you may be limited with resources, having SQL on one of the boxes is really not a great idea as you will be completely hosed if the physical box that SQL is on goes down.

Although, you may not have stated this clearly... do you have a total of 3 boxes? 1 with BES/BAS? 1 with BES/BAS and SQL as primary/mirror and 1 additional for SQL only?? If so, you should be good. If this is the case, I would have the 3rd SQL only box be the primary...

You SHOULDN'T have to do anything for BAS to recognize the sql failover as you indicated this at install time... (that you were configuring SQL mirroring).

Hope this helps.