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

Dell PowerEdge 1950 E1624 Server (9423)
$24.95
Dell PowerEdge 1950 E1624 Server (9423) pictureONE NEW EX-CELL Foldable Chrome Server Tray Stand 6-760 31" Tall
$25.99
ONE NEW EX-CELL Foldable Chrome Server Tray Stand 6-760 31Open House ChannelPlus model H650 Multi-Zone telephone server with voicemail
$45.0
Open House ChannelPlus model H650 Multi-Zone telephone server with voicemail pictureCambro Beverage Dispenser Water Coffee Tea Drink Cooler Catering Server
$50.0
Cambro Beverage Dispenser Water Coffee Tea Drink Cooler Catering Server pictureTortilla Server Warmer 12x2" Black Lift Off Lid Mexican Restaurant Tex-Mex Aztec
$25.99
Tortilla Server Warmer 12x2






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