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
632 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Suggested Solutions

Title # Comments Views Activity
Query Syntax 17 32
create an aggregate function 9 31
Whats wrong in this query - Select * from tableA,tableA 11 28
New to SSRS, extremely slow running report. 8 19
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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 combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

813 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

18 Experts available now in Live!

Get 1:1 Help Now