Viewing 15 posts - 2,311 through 2,325 (of 9,241 total)
what is the recovery model set to on this database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 9:24 am
A backup log command on a secondary replica will truncate the log as necessary on the Primary. This link details the following
SQL Server Books Online
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 7:57 am
DNA_DBA (2/27/2015)
In Win 2008r2 you can take the quorum offline and the cluster will stay up.
depends on your config, generally 2008R2 is not as tolerant as windows 2012
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2015 at 4:10 pm
with minimal startup just master, other than that master and model, tempdb is re created if it doesn't exist. SQL Server Agent wont start if msdb is missing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2015 at 3:48 pm
salnasi (2/27/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2015 at 12:37 pm
can you list out the SPNs and post details of them, obfuscate any names first obviously
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2015 at 9:51 am
taking dtc offline does not affect the cluster.
As for the disk witness it depends on your config.
If you have only 2 nodes in the cluster and a disk witness, you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2015 at 8:50 am
muthyala_51 (2/26/2015)
We are still in testing phase only.
This is the time to iron these things out see which way works best for your scenario
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 10:31 am
POC = Proof Of Concept
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 10:27 am
You still haven't answered my question, did you run any scripts as part of the Readonly routing setup, if so please post details.
If you didn't, then you have no RO...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 10:26 am
slab and trim are more to do with the storage that sits underneath the volume, seems to be a storage system configuration issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2015 at 10:23 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"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
Viewing 15 posts - 2,311 through 2,325 (of 9,241 total)