BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-12-2009, 03:25 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2005
Model: 8300
Carrier: AT&T
Posts: 82
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Move BPS 4.1.4 MSDE database to new server

Please Login to Remove!

Situation is as follows:

Server 2003 running on VMware Server with BPS 4.1.4 installed. This was a temporary solution because the office purchased a new server to implement SBS2008. Since BPS can't run on Server 2008, I went to the VM approach.

The old office server has now been reloaded to Windows 2003 and I want to get off the VM (because it's on a slooow desktop). I don't want to have to re-activate handhelds, I'd like to just move the database.

My plan is to install BPS 4.1.4 on the physical Windows 2003 box and migrate the MSDE DB.

I've found this article, which covers moving from MSDE to a remote SQL Server.

View Document 0 87221896

It's a basic concept. Backup and Restore or detatch/re-attach BESMgmt database. I'm going to be using the exact same folder structure from the Server 2003 VM to the Server 2003 physical box, so I was pkanning to do detatch/re-attach approach.

Should this work without any issue?
Offline  
Old 05-12-2009, 03:52 PM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,724
Post Thanks: 272
Thanked 288 Times in 272 Posts
Default

Do a knife edge cutover.


here are my notes
Bored, so might as well do what I recomend so often, The Knife Edge Cutover
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Offline  
Old 05-12-2009, 04:26 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2005
Model: 8300
Carrier: AT&T
Posts: 82
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Your process indicates you are using remote SQL. If I was doing that, I wouldn't have asked the question, since there's not much to do when the DB location isn't changing.

I am using MSDE on the current box, and will use MSDE on the new box.
Offline  
Old 05-12-2009, 04:50 PM   #4 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,724
Post Thanks: 272
Thanked 288 Times in 272 Posts
Default

Did you look at task 3 in the link provided in my notes?

It covers both MSDE and SQL.

Either way it is about the same except for the database part.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10

Last edited by knottyrope : 05-12-2009 at 04:58 PM.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.