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

Mersen/Ferraz Shawmut 150A High Speed Semiconductor Fuse 300VAC/DC, A30QS150-4
$19.95
Mersen/Ferraz Shawmut 150A High Speed Semiconductor Fuse 300VAC/DC, A30QS150-4 pictureMersen/Ferraz Shawmut 80A High Speed Semiconductor Fuse 500VAC/DC, A50QS80-4
$19.95
Mersen/Ferraz Shawmut 80A High Speed Semiconductor Fuse 500VAC/DC, A50QS80-4 pictureAE TEOS SEMICONDUCTOR GAS INJECTOR vacuum END CAP flange UNUSED
$2250.0
AE TEOS SEMICONDUCTOR GAS INJECTOR vacuum END CAP flange UNUSED pictureNational Semiconductor LP38501TS-ADJ/NOPB IC REG
$4.95
National Semiconductor LP38501TS-ADJ/NOPB IC REG pictureNEW BOX OF 3 - Mersen K301194 - Semiconductor FUSE 1400S - 2 AVAIL
$999.99
NEW BOX OF 3 - Mersen K301194 - Semiconductor FUSE 1400S - 2 AVAIL picture






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