Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

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

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
inverted_2000
Asked:
inverted_2000
  • 3
  • 3
1 Solution
 
YveauCommented:
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
 
inverted_2000Author Commented:
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
 
YveauCommented:
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
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
inverted_2000Author Commented:
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
 
inverted_2000Author Commented:
Awesome...I got it moved over and BES Manager allows login.

Thanks for your help Yveau (o:
0
 
YveauCommented:
Glad I could be of any help and thanks for the grade !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now