Scheduled BlackBerry Professional Software Database Backups
BlackBerry Professional Software Express is installed on your Microsoft Exchange server rather than a seperate server like BlackBerry Enterprise Server requires. When you install BlackBerry Professional Software Express it gives you the option of installing Microsoft SQL Server Express 2005 for the database or using putting the database somewhere else, for example on a server running a full version of Microsoft SQL Server.
Microsoft SQL Server 2005 does not have the ability to setup a maintenance plan so to backup the BESMgmt database you will have do work around this. Install Microsoft SQL Server Management Studio Express on your Exchange server if it is not installed. Once installed open it up, expand databases, and right click BESMgmt and go to Taks then Back Up...
You should be able to leave most of the options at their default, make sure that the location of the SQL backup is in a directory that will be backed up and taken off site.
Click options on the left hand side and select "Overwrite all existing backup sets" and "Verify backup when finished".
Once you have done this click the script drop down arrow at the top and save it to a file. Use the file name BESMgmtBackup.sql, I saved mine to the default directory which is where the backup file will be written to as well.
Open a command prompt and run the command below. You will need to change <InstanceName> to the name of your SQL instance (probably the name of your server), you will also need to change the path to your .sql file if you changed it from the default.
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" -S <InstanceName> -i "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\BESMgmtBackup.sql"
If the command runs successfully open scheduled tasks and create a new one, in the run field paste in the above command. Change the run as field to a domain user account that is setup as your serviceacct (a user that is locked down as a domain admin to run processes). Switch to the schedule tab and set it to run daily at 9AM, click OK and put in the password of the account you used.
Once the job has been created run the job to ensure that it runs successfully, if it runs successfully run it again to be sure that it overwrites correctly as it was setup to do.
May 26th, 2009 - 22:26
Hi,
my company will evaluate Blackberry professional Express edition to provide network engineer tool for monitoring the network. so from BB handset engineer can doing telnet / ssh / vnc etc.
how we integrate blackberry handheld with BPE ? we search best pratice around the google, but it seem not yet available
June 2nd, 2009 - 09:49
I have never done Telnet, SSH, or VNC from my BlackBerry to anything, I would assume there are applications that would allow you to do this but I have never searched for one. In terms of implementing a BPS at your company the basic requirements would be a Windows 2000/2003 server running Exchange 2003/2007 and BlackBerry phones with an enterprise data plan.
Below are links on how to install a BES for Exchange 2003 and 2007, these assume that you are installing a BES which goes on another server. So if you are installing BPS you would do all of this on the Exchange server.
http://forums.crackberry.com/f50/exchange-2003-bes-install-guide-6234/
http://www.blackberryforums.com/bes-admin-corner/75885-exchange-2007-bes-install-guide-100-fully-functional.html