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
626 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
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 2

Author Comment

by:inverted_2000
Comment Utility
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
Comment Utility
Awesome...I got it moved over and BES Manager allows login.

Thanks for your help Yveau (o:
0
 
LVL 18

Expert Comment

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

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now