Viewing 15 posts - 4,126 through 4,140 (of 9,244 total)
ginolard (5/8/2013)
Right, well, the person who installed this cluster (who was fired some months ago) appears to have decided to use BOTH.
Probably why they were fired 😉
Use either\or never both.
ginolard...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2013 at 9:08 am
ginolard (5/8/2013)
Nice article thanks.
You're welcome, I hope you found it useful
ginolard (5/8/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2013 at 7:27 am
SQLSACT (5/8/2013)
Now, I am setting up an AG with no FCI - Because both nodes are in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2013 at 5:24 am
ginolard (5/7/2013)
Local Adapater: Default
Initiator IP: Default
Target Portal IP: Default
Are you saying these values should be changed to this?
Local Adapater: Microsoft...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2013 at 12:17 pm
SQLSACT (5/7/2013)
So I understand that when combining FCI with AG, automatic database failover is gone
Yes that is correct.
SQLSACT (5/7/2013)
but you still have automatic instance failover. Am I correct in this?
Yes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2013 at 11:55 am
sql-lover (5/6/2013)
it happened again. Now, not sure if it was the same or not.I'll take notice though, thanks for reply.
Have you made the changes in the iscsi initiator?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2013 at 2:36 am
sql-lover (5/2/2013)
-Change the network binding order. Put HeartBeat second and SAN last (SAN was 2nd and heartbeat the last one)
I can sort of see why but I don't see this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 3, 2013 at 12:18 am
Check windows firewall, also check remote connections are enabled to sql server too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 2:01 pm
More detail may be found here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 11:48 am
Sqlism (4/30/2013)
What all ports should be opened for a named instance, which is listeneing on 1477.
The named instance name is PDCZV\CZV01
When security opened port number 1477, the developers are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 2:48 am
vishalsurya50 (4/29/2013)
I get the following below error .Kindly check and let me know what should be done in initiating iscsi disk.
Validate Disk Access Latency
Description: Validate acceptable latency for disk...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 12:34 am
Count(*) includes rows with null values whereas count(id) would not include rows with a null id. Unlikely if the id is a primary key though, so it does depend on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 12:16 am
One question springs to mind
If you had a resource in your cluster group marked as failed why on earth would you think the update would still be successful??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 12:09 am
deep_kkumar (4/30/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 12:01 am
Isabelle2378 (4/30/2013)
Hi,I have a filegroup with one large datafile that is 300GB and I want to create 10- 30GB files and spread the data across them for better performance.
Create a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2013 at 11:40 pm
Viewing 15 posts - 4,126 through 4,140 (of 9,244 total)