Friday, March 12, 2010

Blackberry DB Backup BESMgmt BlackberryDBBackup.exe

Ok, so if anyone is interested in backing up the MSDE database for the Blackberry Enterprise Server, you may have come across a command called blackberrydbbackup.exe. And you most likely would have run into issues with using it. The help when executing the program without switches shows a command -d for specifying the database, -E for using windows credentials, and -f for the backup folder: blackberrydbbackup.exe -d BESMgmt -E -f c:\backup That does not work, no matter what you seem to do. Even though Blackberry support and all forums show it as being the proper command sequence. Well after a half hour of hitting my head against the wall, a solution was born. blackberrydbbackup -dBESMgmt -E -f c:\backup Note the no space after the -d and the .exe taken out. When the script was written, it seems someone made a few mistakes. The .exe extension is taken as a part of the switch it seems. And the help needs to be modified to reflect the -ddbname. Dont even bother using -U and -P for username and password. Nothing i tried worked. -Udomain\besadmin -Udomain\BESAdmin -U domain\besadmin -U domain\BESAdmin -Ubesadmin -UBESAdmin -U BESAdmin -U besadmin -UBESAdmin@domain -U BESAdmin@domain -U: all of the above and the same for -P ofcourse. When scheduling the script for this using Windows Scheduler, -E is enough as the windows credentials will be passed. Just enter the besadmin info when saving the job. Someone posted online about using the AT command to run as a system service along with -U and -P so as to not have to change the password for the job each time the Besadmin pw changed. That makes no difference as even if you got the -U and -P to work properly, when the besadmin pw is changed you would still have to modify the script with the new -P. By the way the tool along with blackberrydbrestore.exe is located in the tools folder on the Blackberry cd. Thank you Alex B