Solved

SQL Database Move Question (Blackberry Server)

Posted on 2013-01-08
7
508 Views
Last Modified: 2013-01-08
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.
0
Comment
Question by:Bransby-IT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38754330

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
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38754336
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38754368
not sure why this is written like this in the "move" script, as the "move" implicitly moves a fully working database...
0
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 
LVL 3

Author Comment

by:Bransby-IT
ID: 38754398
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38754458
yes, that should do it (for the database move as such).
0
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38755176
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38756038
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question