BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-18-2012, 11:06 AM   #1 (permalink)
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: Z10
Carrier: Vodafone (UK)
Posts: 463
Post Thanks: 21
Thanked 3 Times in 3 Posts
Default SQL Mirroring with BES 5.0.3 - upgrading

Please Login to Remove!

I have seen many posts that reference the same query but couldnt find a clear-cut answer or way forward.

We have SQL mirroring in place (without witness), all works fine (failover etc.)

But in a scenario where an upgrade is done on the DB, do we have to break the mirror, upgrade active node/db, backup the DB, restore full to mirror DB and recreate the Mirror ? Or as the RIM guide says (Knowledge Sharing - Requirements for database mirrong for BES 5.0 SP2 HA) or mentioned in other posts, upgrade Active node/DB, failover and upgrade the other Node ?

Personally I feel the RIM option may not work and the 1st option is the safest, but what interested to know what others have tried and tested ?
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

Similar Threads for: SQL Mirroring with BES 5.0.3 - upgrading
Thread Thread Starter Forum Replies Last Post
BES 5.0.1 to 5.0.2 upgrade - HA SQL Mirroring Question Tacfire11 BES Admin Corner 1 09-30-2010 01:55 AM
Upgrading from BES Small Business to Pro - SQL issue rmd0311 BES Admin Corner 9 06-24-2009 05:24 PM
BES 4.1.6 SQL Database migration to SQL 2005 Cluster Environment jwor BES Admin Corner 3 12-23-2008 12:09 PM
BES Service Account and SQL Confusion cwood BES Admin Corner 3 03-31-2006 05:50 PM

Lot of 3 Wiped Seagate 750GB 7200 RPM 3.5" ST3750640NS OEM Apple Hard Drives
$89.99
Lot of 3 Wiped Seagate 750GB 7200 RPM 3.5Seagate 750GB 7200 RPM 3.5" ST3750640NS OEM Apple Hard Drive Wiped
$35.99
Seagate 750GB 7200 RPM 3.5CC8: Genuine OEM Apple Mac LONG DVI to VGA Video Adapter Cable 603-2120/591-011
$9.34
CC8:  Genuine OEM Apple Mac LONG DVI to VGA Video Adapter Cable 603-2120/591-011 pictureOEM Part HARD Drive assembly 250mb SCSI Oerlikon 901-416 APPLE iTRADE-AG with c
$137.5
OEM Part HARD Drive  assembly 250mb SCSI Oerlikon 901-416 APPLE iTRADE-AG with c pictureUU5: Apple OEM A1036 45W AC DC Power Adapter Charger Powerbook G4, iBook G3
$12.71
UU5: Apple OEM A1036 45W AC DC Power Adapter Charger Powerbook G4, iBook G3 picture






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