BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 01-09-2008, 08:45 PM   #1 (permalink)
New Member
 
Join Date: Jan 2008
Model: SK65
PIN: N/A
Carrier: Telstra
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Missing BESMgmt.mdf

Please Login to Remove!

Hi All,

We had a problem with our SAN that required that the Blackberry server be recovered from backups and have since found that the SQL db's were not being backed up. The Domino instance recovered fine, however we are now missing all of the SQL db's therefore preventing BES starting.
Any ideas on the best way to recover these db's?
Offline  
Old 01-12-2008, 06:18 PM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Welcome to the forums; unfortunately you're toast. You've got to start over.
Offline  
Old 01-13-2008, 06:38 PM   #3 (permalink)
New Member
 
Join Date: Jan 2008
Model: SK65
PIN: N/A
Carrier: Telstra
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply.
I thought that was going to be the case, just hoping there was a trick to rebuild from the domino db's.
Reinstalled software, recreated user accts and used OTA EA to bring the punters back online.
Offline  
Old 01-13-2008, 07:06 PM   #4 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

All the important stuff is stored in the BESMgmt db.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 01-14-2008, 05:47 AM   #5 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

Actually if you have an almost complete BES folder, then after recreating the BESMgmt db, you can run the nbesmigration.exe to populate the records back. Should not need to re-EA I think. Just an untested idea.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 01-14-2008, 07:13 AM   #6 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Once your BES is up and running I would backup the DB and move it somehwere safe. Then, whenever you make any significant changes: new user/remove user/new hh for user, I would back it up again. That way if you have another crash like that you can recover a little easier.
Offline  
Old 01-14-2008, 07:20 AM   #7 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

... better yet, if you're using MSDE ... Script to perform a scheduled BESMgmt DB Backup & FTP to remote server
Offline  
Old 01-14-2008, 11:10 AM   #8 (permalink)
CrackBerry Addict
 
mahoward's Avatar
 
Join Date: May 2005
Model: 8900
Carrier: T-Mobile
Posts: 560
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

@noname

I am highly intrigued by this idea. I will do some lab testing today and if I can get it to work will post the steps required.
__________________
BESX 4.1.7 on Exchange 2003: 65 Devices
BESX 5.0.3 on Exchange 2003: 2007 Devices
Offline  
Old 01-14-2008, 11:24 AM   #9 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

sounds like a hell of a blog post; you're due anyway
Offline  
Old 01-16-2008, 12:41 PM   #10 (permalink)
CrackBerry Addict
 
mahoward's Avatar
 
Join Date: May 2005
Model: 8900
Carrier: T-Mobile
Posts: 560
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Ha! Yes I am due. I am a lazy lazy man.

Well got it to work (wow!), but with some caveats. All the ugly is here:

BlackBerry Enterprise Server on Domino Discussion: How to Recover* from a Total Loss of BESMgmt SQL database (* with caveats...)
__________________
BESX 4.1.7 on Exchange 2003: 65 Devices
BESX 5.0.3 on Exchange 2003: 2007 Devices
Offline  
Old 01-16-2008, 01:27 PM   #11 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Now time for a backup plan as suggested above
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.