BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 02-24-2011, 11:12 AM   #1
amir4u
Thumbs Must Hurt
 
Join Date: Feb 2011
Model: 7100
PIN: N/A
Carrier: donno
Posts: 68
Default I want to deploy BES COnfiguration Database Mirroring in Prod

Please Login to Remove!

Hi,

I already have the following:

BAS Server 01 and 02
BES Primary
BES Standby

Connecting to SQL 2005 Database

It's all working fine.

Now I want to introduce Database mirroring....

What would be the precautions I should be aware of?

Thanx in Advance
Offline  
Old 02-24-2011, 11:29 AM   #2
fadmin
BlackBerry Extraordinaire
 
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
Default Re: I want to deploy BES COnfiguration Database Mirroring in Prod

It should work as long as you use deafult instance and port on the SQL server.
Offline  
Old 02-24-2011, 12:00 PM   #3
amir4u
Thumbs Must Hurt
 
Join Date: Feb 2011
Model: 7100
PIN: N/A
Carrier: donno
Posts: 68
Default Re: I want to deploy BES COnfiguration Database Mirroring in Prod

So i should do the following? plz correctme if I am wrong...

1) Get another Server
2) Install same SQL server with same version and build
3) give same database name and and port

...... I hope i am not missing anything...

actually i'm gona request the SQL guy to do this but i need to give him proper steps

Regards,
Amir.
Offline  
Old 02-24-2011, 12:04 PM   #4
fadmin
BlackBerry Extraordinaire
 
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
Default Re: I want to deploy BES COnfiguration Database Mirroring in Prod

This link is newer:
http://www.blackberry.com/btsc/KB21884

Last edited by fadmin; 02-24-2011 at 12:06 PM..
Offline  
Old 02-24-2011, 12:05 PM   #5
amir4u
Thumbs Must Hurt
 
Join Date: Feb 2011
Model: 7100
PIN: N/A
Carrier: donno
Posts: 68
Default Re: I want to deploy BES COnfiguration Database Mirroring in Prod

Also, this is out test environment. In our Prod we have two SQL servers but they are not configured as mirror, they are clustered.

So whats are Pros and Cons of BES confi databases as "MIrrored" and as "Clustered" ?
Offline  
Old 02-24-2011, 12:11 PM   #6
fadmin
BlackBerry Extraordinaire
 
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
Default Re: I want to deploy BES COnfiguration Database Mirroring in Prod

Failover clusters provide high-availability support for an entire Microsoft SQL Server instance, in contrast to database mirroring, which provides high-availability support for a single database. Database mirroring works between failover clusters and, also, between a failover cluster and a nonclustered host.
Offline  
Old 02-24-2011, 12:22 PM   #7
amir4u
Thumbs Must Hurt
 
Join Date: Feb 2011
Model: 7100
PIN: N/A
Carrier: donno
Posts: 68
Default Re: I want to deploy BES COnfiguration Database Mirroring in Prod

So if primary configuration database is down then, in a clustered environment, without mirroring configured, will BES primary automatically try to connect to 2nd working Configuration database, if connection is ok? or would it have to be all done manually.

In mirroring it is suppose to do that if connection is ok.
Offline  
Old 02-24-2011, 12:38 PM   #8
fadmin
BlackBerry Extraordinaire
 
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
Default Re: I want to deploy BES COnfiguration Database Mirroring in Prod

I'd suggest you discuss that with your database ppl if you have them but you can read here in really simple way what cluster puts on the table:

An Introduction to SQL Server Clustering

One very important aspect of clustering that often gets overlooked is that it is not a complete backup system for your applications. It is only one part of a multi-part strategy required to ensure minimum downtime and 100% recoverability.

The main benefits that clustering provides is the ability to recover from failed server hardware (excluding the shared disk) and failed software, such as failed services or a server lockup. It is not designed to protect data, to protect against a shared disk array from failing, to prevent hack attacks, to protect against network failure, or to prevent SQL Server from other potential disasters, such as power outages or acts of God.

Clustering is just one part of an entire strategy needed to help reduce application downtime. You will also need to purchase a shared disk array that offers redundancy, make tape backups, put the server behind a firewall, make sure your network connections have redundancy, use battery backup, and locate the server in a secure facility, among many other steps you can take. So donxxx8217;t think that clustering is all you need for creating a highly available SQL Server. Clustering is just one part and database mirroring is another.
Offline  
Old 02-25-2011, 08:40 AM   #9
amir4u
Thumbs Must Hurt
 
Join Date: Feb 2011
Model: 7100
PIN: N/A
Carrier: donno
Posts: 68
Default Re: I want to deploy BES COnfiguration Database Mirroring in Prod

ok thanx
Offline  
Closed Thread



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads for: I want to deploy BES COnfiguration Database Mirroring in Prod
Thread Thread Starter Forum Replies Last Post
BES Licensing Thread BBAdmin BES Admin Corner 223 01-30-2016 04:54 PM
Adding a temp BES to a live database AntiLochus BES Admin Corner 18 12-14-2008 06:59 PM
BES basics questions: requirements, load, encryption, AD, etc. tollers BES Admin Corner 4 03-03-2008 08:06 AM
application of a service pack on a BES with a remote SQL database booster BES Admin Corner 2 06-26-2006 08:38 AM
BES 4.0 SP1 for Exchange now available! jibi BES Admin Corner 20 05-04-2005 10:00 PM


Vintage Apple Computer 4” Paper Cube Notepad Macintosh 80s 90s Office White picture

Vintage Apple Computer 4” Paper Cube Notepad Macintosh 80s 90s Office White

$39.95



6502 CPU - Over 100 chips on a vintage 4 inch Silicon wafer picture

6502 CPU - Over 100 chips on a vintage 4 inch Silicon wafer

$275.00



Vintage Post-it Note Pad Apple Magnetic Holder Pince A Notes Unused 1988 NOS picture

Vintage Post-it Note Pad Apple Magnetic Holder Pince A Notes Unused 1988 NOS

$12.74



Apple 1 Replica IC's: Vintage IC’s Many Types See List NOS 74XXX Types - Apple I picture

Apple 1 Replica IC's: Vintage IC’s Many Types See List NOS 74XXX Types - Apple I

$20.00



Lot of 6 Vintage Apple Drawstring Bags For iPhone, Mac, Apple Watch, iPod picture

Lot of 6 Vintage Apple Drawstring Bags For iPhone, Mac, Apple Watch, iPod

$45.00



Retro 1951 Apple Computer Logo 0.7mm Ballpoint Black Ink Pen Gold Barrel picture

Retro 1951 Apple Computer Logo 0.7mm Ballpoint Black Ink Pen Gold Barrel

$56.41







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