SQL DB Migration
Hello All,
I am rather new to my organization where I replaced the previous BES admin so please forgive my n00bishness... Backstory: BES 5.0.3, configured with some HA available on 2 servers(1vm 1physical). DB's are stored on seperate dedicated SQL cluster. My SQL cluster hardware is up for lease replacement this Qtr and I have 1 week to move my BES DBs to the new hardware. I have 3 db's on the cluser: besmgt, mdsis, bmsstore. The DB team wants to use DNS aliases in the future for all DB's so I will need to repoint from server\DB to alias\DB and then in future changes the alias will change in DNS and everything should be happy. I have looked at a lot of documentation and nobody has really put a procedure or a post about doing this before. I haven't really found a procedure for changing the bmsstore db or the mdsis db. Do I just re-install the app and tell the installation about my new alias\db name? This is all I have found for the mdsis db online but there has to be a better way. Or do I go into the registry for the bmsstore db and change the server\db entries to alias\db? How about the besmgt DB? Can I just change the registry settings or do I need to go through the install and point to alias\besmgt? Keep in mind that I am creating the alias to point to my current DB server and then the night of the SQL cut-over I will stop all BB services and change my alias to point to new server where a backup and restored DB will be waiting. Does this make sense at all and do you think it could work? Thanks for your time!! Adam |
Re: SQL DB Migration
We just did something similar to this, but we also upgraded SQL from 2005 (on a physical server) to 2008 (on a VM)
Below is the procedure I wrote. Feel free to modify as you see fit. All information attached is gleaned directly from BlackBerry Technical Solution Center BTW - You don't need the MDSIS database if you're running BES 5.0.3. KB25012-"Upgrade Issues" prompt appears when upgrading to BlackBerry Enterprise Server 5.0 SP3 **** SQL 2005 to SQL 2008 R2 VM The BlackBerry® Enterprise Server services must be stopped during the process described in this article. To move the BlackBerry Configuration Database to a new Microsoft® SQL Server® instance, complete the following tasks:
Task 1 - Back up the BlackBerry Configuration Database To back up the BlackBerry Configuration Database, complete the appropriate steps for the environment: Microsoft SQL Server 2000 to 2008[LIST=1][*]Open Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 or 2008).[*]Right-click the BlackBerry Configuration Database (for example, BESMgmt).[*]Select Backup Database.[*]Click Add to specify the Directory Name and File Name.[*]Click OK to accept the settings.[*]Click OK again to start the backup process.[*]Close Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 or 2008) when the process is complete.[\list] ________________________________________ Task 2 - Prepare the new Microsoft SQL Server To prepare the Microsoft SQL Server, complete the following steps: Step 1Depending on the environment, assign the appropriate permissions. Note: Complete this task using an account with administrator access to the new Microsoft SQL Server. Microsoft SQL Server 2005 or 2008 requires the following server role permissions: System Administrator, Database Creator. Microsoft SQL Server 2000 to 2008
Step 2Depending on the environment, turn on the correct server protocols. Microsoft SQL Server 2008 Express or Microsoft SQL Server 2008
Step 3Make sure that the Microsoft Server Agent service is running.
Step 4Update the BlackBerry Configuration Database schema. KB03640-How to upgrade a remote BlackBerry Configuration Database Important: If the BlackBerry Enterprise Server software was installed to create a blank BlackBerry Configuration Database on a new Microsoft SQL Server instance, do not perform the following task, because the schema has already been updated.
Task 3 - Restore the BlackBerry Configuration Database Depending on the environment, use one of the methods below to restore the BlackBerry Configuration Database. There are two methods available: restoring the BlackBerry Configuration Database from a backup, or detaching and re-attaching the BlackBerry Configuration Database files. BlackBerry Configuration Database on a Microsoft SQL Server with a different directory structure
1> restore database <BlackBerry_Configuration_Database_name> from disk = "C:\<BlackBerry_Configuration_Database_name>.b ak" with move "<BlackBerry_Configuration_Database_name>_data " to "<new_path>\MSSQL\Data\<BlackBerry_Configuration_D atabase_name>.mdf", move "<BlackBerry_Configuration_Database_name>_log" to "<new_path>\MSSQL\Data\<BlackBerry_Configuration_D atabase_name>.ldf" 2> go 3> quitNote: To determine the logical file names <BlackBerry_Configuration_Database_name>_data and <BlackBerry_Configuration_Database_name>_log for the BlackBerry Configuration Database, complete the following steps:
Task 4 - Configure the BlackBerry Enterprise Server For BlackBerry Enterprise Server 5.0 BlackBerry Enterprise Server 5.0 does not have a change database option like previous versions. KB18129 explains the process for BlackBerry Enterprise Server 5.0. It is best practice when moving the BlackBerry Configuration Database to shut down all services pointing to the existing database before taking a full database backup to minimize any data loss during the move. The createdb utility can be used to create a blank database in the new location so the database server will have the required information about the new database. Once the blank database is created, a full database restore must be performed. To configure the BlackBerry Enterprise Server to use a new BlackBerry Configuration Database or a new database server, run the setup.exe again by following the steps below:
Please see KB23428 if xxx8220;Error initializing systemxxx8221; error appears when starting BlackBerry Enterprise Server 5.0 SP2 and 5.0 SP3 setup. Links and Resources KB03112-How to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance KB03640-How to upgrade a remote BlackBerry Configuration Database KB18129-How to point to a new BlackBerry Configuration Database in BlackBerry Enterprise Server 5.0 KB23428-xxx8220;Error initializing systemxxx8221; error appears when starting BlackBerry Enterprise Server 5.0 SP2 and 5.0 SP3 setup |
Re: SQL DB Migration
Excelent news about mdsis!
So if I am reading everything correctly all I have to do is run the BB setup and specify the new DB name. This is way easier than I thought it would be. |
Re: SQL DB Migration
Yep yep. Just be sure that you have made a backup of the DB and restored it in the new destination location.
Then run setup.exe |
All times are GMT -5. The time now is 04:58 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.