Viewing 15 posts - 4,126 through 4,140 (of 9,241 total)
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
Jeffrey Williams 3188 (4/29/2013)
switch recovery model back to full - take a full backup - and restart your transaction log backups.
Taking a diff backup instead of a full maybe quicker...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2013 at 8:15 pm
Surely you mean 😉
Steve JP (4/27/2013)
1)switch to simple recovery2)backup database
3)checkpoint database
4)shrink log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 7:27 am
You can apply an SP and CU when slipstreaming an install, but the PCUSource and CUSource parameters do not apply to straight SP or CU installs.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2013 at 7:22 am
Viewing 15 posts - 4,126 through 4,140 (of 9,241 total)