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
629 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
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 500 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
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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.

863 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

24 Experts available now in Live!

Get 1:1 Help Now