Viewing 15 posts - 2,326 through 2,340 (of 9,244 total)
ok, so what scripts did you run to configure readonly routing?
Would expect to see something like this
ALTER AVAILABILITY GROUP [STOKEAG_1] MODIFY REPLICA ON
N'STOKECSCLNODE1\INST1' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));
ALTER AVAILABILITY GROUP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 10:15 am
sherrerk (2/26/2015)
I am no problem connecting to the secondary node using its host name, but can not get to it through the listener using the applicationintent=readonly.
Can you provide details of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 9:52 am
this looks pretty good and mentions netapp specifically
http://blogs.msdn.com/b/clustering/archive/2010/05/23/10015174.aspx?PageIndex=57
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 9:46 am
muthyala_51 (2/26/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 9:40 am
to identify instance names to PIDs use either SQL server configuration manager or windows task manager.
In sql config manager the process id can be seen in the SQL Services window
For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 7:11 am
Anshul Parmar (2/26/2015)
I have given all permissions, still same issue.
Full permission to who??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 6:49 am
The error 3 indicates a lack of ntfs permissions on the file location.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 12:39 am
Is this a windows server failover cluster?
Are you using cluster shared volumes?
Can you provide more detail around this particular volume itself, I.e. How it was formatted, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 12:26 am
You'll need to supply more detail, is this a new instance youre installing or an existing instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 12:20 am
Are the nodes on separate geographical sites or are they both located in the same location. Since youre planning to use alwayson availability groups storage shouldnt be of any concern....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 12:17 am
a 2 node cluster will need a witness to attain quorum. If it's a same site cluster you could use a disk witness, if it's a cross site cluster use...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2015 at 9:04 am
spaghettidba (2/24/2015)
Perry Whittle (2/24/2015)
do not evict the node, this is not the correct action.
Why wouldn't it work? I'm pretty sure I have done this in the past.
I'm not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 25, 2015 at 7:59 am
use a powershell job step instead and use the following
$checkdate = (get-date).AddDays(-30)
$checkpath = "C:\Program Files\MSSQL10_50.MSSQLSERVER\MSSQL\Log\*"
echo "The checkdate is "
echo $checkdate
get-childitem $checkpath -Include *.sqb | ?{$_.LastWriteTime -lt $checkdate} | remove-item
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 10:04 am
do not evict the node, this is not the correct action.
The restriction on how many nodes may host a clustered instance of SQL Server in Standard edition is within...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 9:48 am
you actually configured it to listen on 1433?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 9:40 am
Viewing 15 posts - 2,326 through 2,340 (of 9,244 total)