Viewing 15 posts - 2,326 through 2,340 (of 9,253 total)
Post the results of this query run against the primary replica
selectreplica_id
, group_id
, replica_metadata_id
, replica_server_name
, owner_sid
, endpoint_url
, availability_mode
, availability_mode_desc
, failover_mode
, failover_mode_desc
, session_timeout
, primary_role_allow_connections
, primary_role_allow_connections_desc
, secondary_role_allow_connections
, secondary_role_allow_connections_desc
, create_date
, modify_date
, backup_priority
, read_only_routing_url
from...
February 26, 2015 at 10:21 am
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...
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...
February 26, 2015 at 9:52 am
muthyala_51 (2/26/2015)
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...
February 26, 2015 at 7:11 am
Anshul Parmar (2/26/2015)
I have given all permissions, still same issue.
Full permission to who??
February 26, 2015 at 6:49 am
The error 3 indicates a lack of ntfs permissions on the file location.
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
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?
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....
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...
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...
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
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...
February 24, 2015 at 9:48 am
Viewing 15 posts - 2,326 through 2,340 (of 9,253 total)