SQL Database Move Question (Blackberry Server)

I am about to move my Blackberry SQL database onto my new SQL Server.

I am following the folowing link documentation.

LINK HERE

I have two questions.

1- Task 1 - Back up the BlackBerry Configuration Database
    What does the following command do?
    osql -E -S <SQL_Server_name>\<instance_name>

2- Task 2 - Prepare the new Microsoft SQL Server
    Step 4 - Update the BlackBerry Configuration Database schema.

    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.

I built a new Blackberry Server a few months ago.   I did this using a new SQL database.  
Do I need to do this?

Thanks for your help.
LVL 3
Bransby-ITAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:

1. osql (task 1)

the osql command line tool is used to execute sql statements on your instance (your db) -E means "connect using windows authentication", and -S <...> specifies the server and sql instance name to connect to.
once that tool connected, the steps below (backup ....) statements are to be run on the "command prompt" of the osql tool.

2. bb schema database

from what I understand: no. you did create the database already, as you say
0
 
Bransby-ITAuthor Commented:
OK I have already taken a backup of the Database, I intend to detatch it and then move it and re atatch it.  

So what would be the reason I perform this command?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
not sure why this is written like this in the "move" script, as the "move" implicitly moves a fully working database...
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Bransby-ITAuthor Commented:
So I can just add the BESadmin Username to the new SQl Server Login
Detach
Move (I am also moving the two files but I want the log files in a different location to the database)
Reattach?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, that should do it (for the database move as such).
0
 
Bransby-ITAuthor Commented:
I am getting the following error when running the BlackBerry Setup

Bes Error
I have detached moved and Attached the SQL Database and the Logs.

Any ideas?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
great ... instead of also giving the actual error message to troubleshoot the connection issue, that setup only gives some "hint" that there is an error ... :(
any "setup log file" with more details?
0
All Courses

From novice to tech pro — start learning today.