Viewing 15 posts - 3,316 through 3,330 (of 9,244 total)
support-555807 (4/30/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2014 at 7:22 am
SQLSteve (4/30/2014)
Sean Lange (4/29/2014)
SQLSteve (4/29/2014)
Would you put...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2014 at 7:11 am
dexdev (4/30/2014)
Seems like the correct solution would be to go with one larger db.
Clarify what you mean by one db, do you mean 1 instance?
The 2 terms have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2014 at 1:46 pm
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
Viewing 15 posts - 3,316 through 3,330 (of 9,244 total)