KB12714 - Move the BlackBerry MDSS databases to a new Microsoft SQL Server or ...

hdawg · #1 (**permalink**) 07-06-2009, 11:27 PM

KB12714 - Move the BlackBerry MDSS databases to a new Microsoft SQL Server or server instance

Environment

BlackBerry® Enterprise Server versions 4.1 service pack (SP) 2 to SP4

Overview

Note: Use the procedure in this article in conjunction with KB03112, which details the steps to move the BlackBerry Configuration Database to a new Microsoft® SQL Server®. The following tasks cannot be used to cut over a BlackBerry Enterprise Server to new hardware.
Perform the following tasks using the account that was used to install the BlackBerry Enterprise Server software unless otherwise stated:
Task 1 - Prepare the Microsoft SQL Server
Create a Microsoft SQL Server user account for BlackBerry® Mobile Data Sytem (BlackBerry MDS) Services. This will need to match the BlackBerry MDS Services (MDSS) account created during the installation process. You can check the server.xml file for the user account and password that is currently used.
Task 2 - Back up and restore the BlackBerry MDS Services databases to the new Microsoft SQL Server.
Important: Restarting the BlackBerry Enterprise Server will delay message delivery to BlackBerry smartphones. For more information, see KB04789.
Perform the following steps:

Stop the BlackBerry Enterprise Server services
1. Open Windows® Services. To do this, go to Control Panel and select Administrative Tools > Services.
2. Stop each service that has a name that begins with BlackBerry.
Back up and restore the BlackBerry MDS Services databases to the new Microsoft SQL Server.
1. Log in to the original Microsoft SQL Server.
2. Open Enterprise Manager.
3. Right-click the BlackBerry MDS Services databases.
4. Select All Tasks and click Detach Database.
5. Close Enterprise Manager.
6. Navigate to the Microsoft SQL Server data directory and make a copy of all files with extensions of MDF and LDF. The default path is C:\Program Files\Microsoft SQL Server\MSSQL\Data\ and the default filenames are mdss.mdf, mdss.ldf, mdss_dis.mdf and mdss_dis.ldf.
7. Move the file copies to the new Microsoft SQL Server data directory.
Attach the BlackBerry MDS Services databases to the new Microsoft SQL Server.
1. Log in to the new Microsoft SQL Server.
2. Open Enterprise Manager.
3. In Enterprise Manager, right-click the Database folder and click All Tasks.
4. Select Attach Database.
5. Select the MDF file to attach.
6. Specify the Microsoft SQL Server user account created in Task 1 as the owner.
7. Click OK.
8. In the Enterprise Manager, expand the databases and then expand the database that was just attached.
9. Left-click Users and delete the entry (MDSS Admin listing) under the dbo entry.
10. In Enterprise Manager, expand the Security folder and select Logins.
11. Double click the MDSS service account and select the Database Access tab. Select the permit check box next to the database that was just attached and make sure that this account is also set as dbo in the Permit in Database Role area.
12. Click OK.
13. Repeat these steps for the other database that you have not attached yet.
14. Close Enterprise Manager.

Task 3 - Change the Microsoft SQL Server name in the server.xml file.
Perform the following steps:

Edit the server.xml file, found in C:\Program Files\Research In Motion\BlackBerry Enterprise Server\MDSS\jakarta-tomcat-5.5.9\conf\.
Add the new Microsoft SQL Server name to all occurrences of url= in the file.
Change the following line: url="jdbc:sqlserver://OLDSQLSERVERNAME:1433;databaseName=mdss;forwardReadOnlyMethod

=serverCursor" username="admin" password="password"
to url="jdbc:sqlserver://NEWSQLSERVERNAME:1433;databaseName=mdss;forwardReadOnlyMethod

=serverCursor" username="admin" password="password"
Note: There are three locations in the server.xml file that must be updated.

Additional Information

This resolution does not apply for BlackBerry Enterprise server versions 4.1 SP5 and SP6 as these databases are no longer able to be migrated in these versions of the software. After migrating the BlackBerry Enterprise Server to a new Microsoft SQL Server or server instance, you will need to reinstall the BlackBerry Enterprise Server in order to recreate the BlackBerry MDS Integration Service databases.

Follow Us On

Forum Sponsors

Google Advertisements