Viewing 15 posts - 6,571 through 6,585 (of 9,241 total)
Its all detailed in the link i sent you.
There are 3 possible quorum modes
Full Quorum.
This is where both partners and witness are connected
Witness to partner.
This is where the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 3:24 am
yes it's a lot of work. I did similar to this in my last contract. I had to rebuild all the cluster nodes one at a time and went through...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 21, 2011 at 3:11 am
just out of interest why are you rebuilding, are you changing server collation?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:28 am
check the cluster.log at the following location for more details
C:\Windows\cluster
or
C:\Winnt\cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:25 am
Theres also an SSIS task to do this which works quite well
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:22 am
Which edition of Windows 2003 SP2 are you using?
Also, could you post the partition details from the boot.ini file on that server too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:21 am
vultar (9/20/2011)
2. uninstall clustered applications from node to be evicted
3. Evict node with command… cluster node <hostname> /evict
4. On node that was...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:17 am
is this a Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:07 am
the easiest way to test as NJ-DBA has already pointed out is to simulate a failure of the public NIC on the active node. Either pull the cable or disable...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 10:04 am
dbychen (9/19/2011)
Thanks Perry.Can MSDTC share a drive owned by the SQL Server or the Quorum drive? Does it require a dedicated drive?
As you know, you may now have multiple clustered...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2011 at 3:43 am
how long do the log backups take to run, may be worth increasing the frequency further if possible
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 4:42 pm
rdavies 35008 (9/19/2011)
So even if the mirroring is paused, you still need to maintain quorum?
if you're running with a witness, yes
rdavies 35008 (9/19/2011)
I've clearly missunderstood the "Pause" function......
Its all detailed...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 4:40 pm
rdavies 35008 (9/19/2011)
the principal database shouldn't have gone offline when I broke the comms link (by shutting down the Firewall)?
Yes it should, because you wiped out the witness too which...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:32 pm
yes, if you want to take the mirror down for a maintenance op or some other business reason then this is what the pause is for. If you plan to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:14 pm
Right, but v 10.00.4035 is post SP2 10.00.4000 so you wont be able to apply SP2. 4035 must be a hotfix release level
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2011 at 3:02 pm
Viewing 15 posts - 6,571 through 6,585 (of 9,241 total)