BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 11-02-2010, 11:21 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2008
Location: Cayman Islands
Model: 8900
OS: 5.0.0.822
PIN: 20ED4C2C
Carrier: DIGICEL - KY
Posts: 30
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Transfer of BESMGMT SQL database from local sql express to Alternate SQL server

Please Login to Remove!

Hello-

I am need of a little assistance, i need to move my BESMGMT mdf and ldf files accross to a full instance of SQL standard, from the local instance of SQL express that it is current setup on; i am running BES Express 5.0.2.29

Can anyone outline what needs to be done?

if it is as easy as detaching the mdf from the local sql and attaching it to the new sql server then all should be good, i just want to ensure that i dont miss anything huge (sql schema related etc)

Thanks,

Josh
__________________
El Josh
Offline  
Old 11-02-2010, 11:22 AM   #2 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 235 Times in 218 Posts
Default

KB12247-How to move from a Microsoft SQL Server Desktop Engine (MSDE) database to a Microsoft SQL Server database
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 11-02-2010, 11:50 AM   #3 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,209
Post Thanks: 369
Thanked 374 Times in 344 Posts
Default

I did this years ago, it is actually fairly straight forward. only mistake I made was not using SSMS with BESAdmin logged in. Quick change of permissions back after restore and all was running well.
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
Offline  
Old 11-02-2010, 05:37 PM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2008
Location: Cayman Islands
Model: 8900
OS: 5.0.0.822
PIN: 20ED4C2C
Carrier: DIGICEL - KY
Posts: 30
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks much
__________________
El Josh
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

VM110 VIC-20 Programmers Reference Guide, Commodore Business Machines
$9.99
VM110 VIC-20 Programmers Reference Guide, Commodore Business Machines pictureMOS 325572-01 Commodore 1541 40-PIN Gate Array (x1)
$7.0
MOS 325572-01 Commodore 1541 40-PIN Gate Array (x1) pictureMOS 901227-03 Commodore 64 C64 Kernal ROM (x1)
$8.0
MOS 901227-03 Commodore 64 C64 Kernal ROM (x1) pictureMOS 906114-01 Commodore 64 PLA 28-Pin PDIP Used-Pull
$25.0
MOS 906114-01 Commodore 64 PLA 28-Pin PDIP Used-Pull  pictureMOS 6502 B Commodore 1541 CPU 40-Pin PDIP Used
$10.0
MOS 6502 B Commodore 1541 CPU 40-Pin PDIP Used  picture






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