Viewing 15 posts - 2,956 through 2,970 (of 9,244 total)
zedtec (9/19/2014)
I just wanted to know, at what stage of the windows cluster setup are Quorum and MSDTC created?
Is it when creating the failover cluster within Server Manager when these...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2014 at 6:03 am
you'll need to speak to your domain admin as they will push AD policies and permission to filter or remove them.
Why are you trying to grant the user RDP access...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2014 at 5:55 am
Scorz (9/18/2014)
Perry Whittle (9/18/2014)
How many network cards are installed\configured on each node?4 NIC on each, teamed
Check the NIC teaming to ensure all NICs are teamed correctly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2014 at 5:16 am
The bus speed is important as is the type of RAM too. If the RAM bus speed exceds the CPU bus speed there's no benefit as it will clock down...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2014 at 5:14 am
Bipsy (9/19/2014)
Hi Experts,We have 2 node sql 2012 cluster and we have a scenario where domain,IPs,Hostanmes and SQL network name are changing.
if you intend to change the hostname for a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2014 at 5:11 am
the logic you put into the classifier function is entirely down to you, tailor as you need it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2014 at 5:01 am
It wasnt for your benefit, as an MCSA i would hope you do know 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 10:51 am
In a standard always on config all replicas are stand alone instances. However, the nodes must all be members of the same windows cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 10:10 am
How many network cards are installed\configured on each node?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 7:48 am
see my guide at these links
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 7:39 am
All of the nodes involved in the AlwaysOn group must be part of the same windows cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 7:31 am
SQLisAwE5OmE (9/13/2014)
When setting up mirroring with witness server, what exactly the role of a quorum?
Quorum is the process by which the current resource owner is logged within a set configuration....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 3:10 am
FlexBrains (9/15/2014)
Everything is working just as expected
Yep, seems reasonable setup to me.
FlexBrains (9/15/2014)
not sure how to utilize Passive Node HA3 for Backups.Any suggestions please?
Flex
Ah, you have deployed Failover Cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2014 at 2:58 am
The only other thing to check is that the SQL Server agent is granted login in the sql instance as sysadmin. Its usually done through the system account like so
NT...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 10, 2014 at 5:21 am
can you post the scripts you're using
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 9, 2014 at 9:24 am
Viewing 15 posts - 2,956 through 2,970 (of 9,244 total)