Viewing 15 posts - 3,316 through 3,330 (of 9,241 total)
this is the behaviour I have observed across SQL server 2012 and 2014. The listener is a VNN and VIP into the instance itself and not the availability group.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 11:02 am
Before you destroy the cluster and the instance don't forget to backup any objects you may want
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 9:05 am
The listener is just a virtual network name and ip which through ssms will connect you straight to the primary replica\instance.
You'll then see what your account grants you access to
Now,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 9:02 am
The listener is just a virtual network name and ip which through ssms will connect you straight to the primary replica\instance.
You'll then see what your account grants you access to
Now,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 8:58 am
456789psw (4/29/2014)
Sounds I like I need to break the C node down to a stand alone server and then add the node to the ALWAYS ON cluster.
How many nodes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 8:28 am
And that's exactly what I would expect it to do, you're connected to the primary instance and will see all databases available to you on that instance.
What are you expecting...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 8:23 am
jayjj (4/28/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 3:55 am
william.rees.howells (4/28/2014)
Instead of creating a secondary filegroup and then dropping and recreating all indexes in the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 3:47 am
456789psw (4/28/2014)
The catch is the C NODE is in a SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 3:42 am
Drop the group and re create it, ensure you note the listener IP address and TCP port first so that you may rercreate it correctly to avoid permanently impacting user...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 3:35 am
jens.riis (4/29/2014)
Will it require a reeboot ?
it might require one before you run the installer if you have a pending reboot.
When installing the new instance it's unlikely to require a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 3:03 am
need a biot more info on the server spec and the resources assigned (such as max mem setting) to the other instances.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 2:57 am
Is the instance of sql server a named instance or default instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 2:54 am
dexdev (4/28/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 2:52 am
andrew gothard (4/28/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2014 at 11:12 pm
Viewing 15 posts - 3,316 through 3,330 (of 9,241 total)