?
Solved

MSDE - Need fast help - Need to move BES MSDE datastore to a new server with MSDE - Need to Know how to do this

Posted on 2007-11-13
6
Medium Priority
?
638 Views
Last Modified: 2013-11-30
Hey everyone,

I built a new BlackBerry BES Server on W2k3 with all that patches etc.

I installed BES software, and it created a new MSDE instance that I mapped to the "D" drive.  This is important because the default location is c:\program files\mic.....\SQL....\Data.  I can't have the DB reside in the default location.  It needs to be on the new data partition that I created "D".  I tried to cold copy the data files with the services off, and when they come back on they fail to log in.

I tried to use SSIS in SQL Server studio to import/export a lot and it fails to do it because there are already instances of Views and other objects in the destination DB.

How can I attached a copy of the old MSDE data store to the new MSDE datastore using OSQL or something like that?

I rather use Studio, but it's not allowing remote mapping of the data files.

Please help and fast (o:

0
Comment
Question by:inverted_2000
[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
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:Yveau
ID: 20275376
you gave the answer: attach it !
In SSMS, connect to the server, right click on the database folder select attach and go through the wizard pointing to your .mdf and .ldf file.

Hope this helps ...
0
 
LVL 2

Author Comment

by:inverted_2000
ID: 20275509
What...

There are 3 computers....#1 is the old, #2 is the new and #3 is my laptop.

I use my laptop to connect to #1 and #2.  I want the DB on #1 on #2, so on my laptop, #3, I attach a copy of the DB from the old #1 server to the #2 server and then change the .mdf and .ldf locations?

that doesn't seem to be what would work.
0
 
LVL 18

Accepted Solution

by:
Yveau earned 2000 total points
ID: 20275628
no ... you should copy the .mdf and .ldf file from machine #1 to machine #2.
then connect (from #3) to machine #2 using SSMS and attach the database using the files that are on #2.
That way, the database is attached on server #2. That is hat you are looking for, right ?

Make sure to stop all SQL Server service on #1 before copying the files ... but you said you did so I'll guess that should be ok. Otherwise, do a detach of teh database and then copy the files from #1 to #2.

Hope this helps ...
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 2

Author Comment

by:inverted_2000
ID: 20275674
I'm sorry...I think I've almost got it with the way you're explaining.

I've been looking at it for too long today.

I'll post back in just a little while.

Thanks a ton,
inverted
0
 
LVL 2

Author Comment

by:inverted_2000
ID: 20275746
Awesome...I got it moved over and BES Manager allows login.

Thanks for your help Yveau (o:
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20275829
Glad I could be of any help and thanks for the grade !
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

801 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