BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-30-2008, 04:42 AM   #1 (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 Correct Steps to manual failover SQL servers

Please Login to Remove!

Hello all,

My experience is limited to the use of the Enterprise Manager and hence need to consult the experts here what are the correct steps to manually failover one SQL server to another using the Cluster Admin client. I need to know as I will be restarting SQL servers one by one for a maintenance window and I wanna make sure my BES servers are failed over to the other SQL server in the SQL Cluster.

E.g. SQLCluster
{
SQLServer1
SQLServer2
}

Any advices? Thanks!
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 05-31-2008, 08:51 AM   #2 (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

None of you guys here use SQL Clustering?
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 06-02-2008, 01:13 AM   #3 (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

Finally managed to find the answers from a good old buddy. Sharing the various methods for manual failover:-

How to Cluster SQL Server 2005
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
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

= SENTRY ELECTRONIC DATA STORAGE PERSONAL ORGANIZER CALCULATOR MEMO VINTAGE =
$4.99
= SENTRY ELECTRONIC DATA STORAGE PERSONAL ORGANIZER CALCULATOR MEMO VINTAGE = pictureVTG FEDERATED FRY METALS SOLDER PLUMBING SPOOL WIRE CORE 9.6 OZ
$9.99
VTG FEDERATED FRY METALS SOLDER PLUMBING SPOOL WIRE CORE 9.6 OZ pictureVintage Lab Glass Pipet Tips 3.5", 2.5" Lengths Lot of 2
$1.99
Vintage Lab Glass Pipet Tips 3.5Steelmaster vintage office desk
$100.0
Steelmaster vintage office desk pictureVintage Pyrex 500 ml Laboratory Test Tube Or Beaker Made In USA
$10.0
Vintage Pyrex 500 ml Laboratory Test Tube Or Beaker Made In USA picture






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