Friday, August 16, 2013

Moving Blackberry Enterprise Server SQL database from one server to another

To move SQL database from one blackberry Server to another:

The process is very simple:(BES and SQL 2005)

1. Take backup of BES database by using sql management studio
2.  Copy the data base folder from BES installer to NEW SQL server, in my case it was extracted in path C:\Research In Motion\BlackBerry Enterprise Server 4.1.7\Database
3.  Edit the BESMGMT.cfg file & enter the BES data base name you want to create on New SQL server
DATABASE_NAME=BESMgmt (in case of SQL instances you ahve to mention instance name\database name)
4. Open command prompt on New Sql server browse to databse path & run createDB.exe with the user that has permissions.
5. Now restore the  database from backup to this newly create database on New SQL Server.
6. Now go to Blackberry enterprise server & open blackberry server configuration from start–>programs menu
7.  Click Change database & wizard will start which will guide you to a smooth process. (blackberry services will stop & start in the process)

If you are using MDS services database then you have to follow some additional steps that are mentioned in below link.

In my case we are not using MDS services.