We have Sharepoint / BES / CRM all using the same SQL 2000 server.
I'm busy moving BES and Sharepoint databases to another SQL 2000 server, leaving me able to do a SQL upgrade to 2005 of just CRM.
Therefore my need to just get the SQL 2000 BES database moved accross to the new SQL 2000 server... The information contained in the How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instance
is very useful indeed, but there are a few minor questions concerning using createdb.exe
that is unclear to me... Whether it is a requirement? / Why one needs to use it? ... I was hoping somebody could fill the gaps allowing me to complete the moving of the the BES SQL database/s?
Using the steps within the Updating the BlackBerry Configuration Database schema
section I've managed to run createdb.exe BESMgmt.cfg
, which creates the BESMgmt database with some tables, store procedures and other database objects, but why use this executable and not just create the database within Enterprise Manager? What is created exactly by this executable? Security roles?
Additionally, I was wondering about mdss
databases? What are these other two for? Are they essential? I see they exist on the current SQL server.
Then my big frustration currently is that I can set within the BESMgmt.cfg where the MDF is to be located, "DB_FILE_DIR=E:\SQL Data" for data, but not where the LDF is to be located ... E:\SQL Data IS where our MDF file should reside and happens to match also where it resides on our existing server, which is wonderful, but I can't seem to set the log files to where I want it? Our LDF file on our existing server is within F:\SQL Logs, and this is where the new server's default log directory has also been set to, and where I'd like the new LDF file for the new BESMgmt
database to reside. Any ideas how to do force this using the BESMgmt.cfg file?
Next, I'm unclear about whether I need to be logged onto the server as the BlackBerry Enterprise Server service account
when I run this command? Does it matter?
I've set the BESMgmt.cfg file to use SQL authentication with SQL user sa
, but what influences the need to use one of Windows / SQL / Mixed authentication methods within the BESMgmt.cfg file when creating the BESMgmt database? Will this affect the working of BES / BES management later?
Lastly, further on in the article, it states Depending on the environment, complete one of the procedures below
, meaning use either backup /restore or detach/attach.. How do I know which option is applicable? Can I use any?
Looking forward to someone being able to fill these gaps for me please? It will be much appreciated as I am struggling to put the pieces of this puzzle together and quite urgently need to get BES related database/s moved in order for me to continue to my next task of transferring WSS, and getting SQL upgraded for CRM purposes...