BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-05-2007, 01:06 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2007
Model: 8800
PIN: N/A
Carrier: Cingular
Posts: 29
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default How often should the BES db be backed up, for DR purposes?

Please Login to Remove!

I'm trying to set up our BES environment for DR.

There is a document located here Livelink - Redirection on how to set up transactional log shipping and also how to fail over a BES and SQL server. I get most of it, but I'm not sure what the guide refers to when it says "set up services that support multiplicity", etc. No idea. Those options aren't even in my BES.

Anway, as a second option, I was considering just having the standby BES with the same SRP and then restoring the db.

How often does the data in a bes db actually change? Would once a day be recoverable if no significant changes were made during that last day (no new users/policies, etc).
Offline  
Old 09-05-2007, 01:29 PM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you haven't made any policy changes, user changes, license changes ... things of that nature, then you're really safe with once a day. You'll lose some statistical information, but you won't lose functionality.

If you decide to create a software configuration and assign / deploy it to users and then your DB crashes and you have no backup since you've created / set for deployment then you'll have to reconfigure.

I generally do hourly backups only because the impact is nil to the SQL server ... but daily is certainly ok. Its better than nothing at all, which unfortunately is what most MSDE installations end up being.
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

50Pcs N25Q032A13ESE40F SOP-8 32MB Nor Flash Memory N25Q032A13ESE40F Micron
$21.99
50Pcs N25Q032A13ESE40F SOP-8 32MB Nor Flash Memory N25Q032A13ESE40F Micron pictureHI-LO ALL-100A Programmer FLASH EEPROM MPU +M1-UN-DP48
$1000.0
HI-LO ALL-100A Programmer FLASH EEPROM MPU +M1-UN-DP48 pictureSelecto 180068 SMF SteamGUARD Flash 5000 Replacement Cartridge
$179.35
Selecto 180068 SMF SteamGUARD Flash 5000 Replacement Cartridge pictureLOT OF 27 - Intermec PN:TE28F016S5-70 16M-BIT Flash 5V TSOP-56 Chips
$8.99
LOT OF 27 - Intermec PN:TE28F016S5-70 16M-BIT Flash 5V TSOP-56 Chips pictureMicrochip PIC32MX795F512L-80I/PT MCU 32BIT 512K FLASH
$9.31
Microchip PIC32MX795F512L-80I/PT MCU 32BIT 512K FLASH  picture






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