[Sagz]

You can also do this:

Just make a bat file with this, you can also automate this so it checks using monitoring. This is a setup for SQL environment, I did this along time ago and figured I would share it again. As for the State DB's just do data copies over. You can also have the 2 domino servers replicate, and just have an agent create new reps as they get created on the primary. If the data is out of date (restore of stat db for example) the user may receive some messages again.



This handles failure besides your SQL db. So for example you can do maint without effecting the userbase. As for the SQL db the only real way is to restore to a different server and point the BES boxes to the new host, which can be batched..

Enjoy.
(This is 4.0 environment there are some tweaks you need to do for a 4.1 environment)

c:
cd\temp
REM ************************************** Stop Blueberry Services
psservice \\<servername>-u <username> -p <password> stop "Blackberry Alert"
psservice \\<servername>-u <username> -p <password>stop "Blackberry Attachment Service"
psservice \\<servername>-u <username> -p <password> stop "Blackberry Controller"
psservice \\<servername>-u <username> -p <password> stop"Blackberry Mobile Data Service"
psservice \\<servername>-u <username> -p <password> stop "Blackberry Policy Service"
psservice \\<servername>-u <username> -p <password> stop "Blackberry Dispatcher"
psservice \\<servername>-u <username> -p <password> stop "Blackberry Router"
psservice \\<servername>-u <username> -p <password> stop "Blackberry Synchronization Service"

Sleep 5

OSQL -E -i c:\temp\Raspberry.sql

sleep 3


c:
cd\temp
REM ************************************** Start Raspberry Services
psservice psservice \\<servername>-u <username> -p <password> start "Blackberry Alert"
psservice \\<servername>-u <username> -p <password> start "Blackberry Attachment Service"
psservice \\<servername>-u <username> -p <password> start "Blackberry Controller"
psservice \\<servername>-u <username> -p <password> start "Blackberry Mobile Data Service"
psservice \\<servername>-u <username> -p <password> start "Blackberry Policy Service"
psservice \\<servername>-u <username> -p <password> start "Blackberry Dispatcher"
psservice \\<servername>-u <username> -p <password> start "Blackberry Router"
psservice \\<servername>-u <username> -p <password> start "Blackberry Synchronization Service"


The SQL script is as follows.

use BESMgmt
go
update ServerConfig set ServiceName = 'CN=Raspberry/OU=SRV/O=LAB where ID=1
update ServerConfig set MachineName = '<machinename.something.yada>' where ID=1
update MDSConfig set MDSHost = '<machinename.something.yada>' where ID=1
go