Viewing 15 posts - 6,586 through 6,600 (of 9,253 total)
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...
September 20, 2011 at 10:17 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...
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...
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
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...
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...
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...
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
September 19, 2011 at 3:02 pm
Books Online
If all the server instances become disconnected from each other, the session is said to have lost quorum. As server instances reconnect to each other,...
September 19, 2011 at 2:55 pm
If you know you're taking both down, remove the witness first then pause the mirror.
September 19, 2011 at 2:41 pm
Preventative maintenance?
Out of interest how often do you run transaction log backups?
September 19, 2011 at 2:18 pm
in synchronous mode with a witness the loss of the mirror partner and the witness will take the principal database offline.
Why did you pause the mirror if you were taking...
September 19, 2011 at 2:11 pm
check for further info in the cluster.log
This is located in C:\Windows\Cluster or C:\Winnt\cluster
September 19, 2011 at 10:17 am
Viewing 15 posts - 6,586 through 6,600 (of 9,253 total)