Viewing 15 posts - 2,311 through 2,325 (of 9,244 total)
You must remove the primary database from any log backup maintenance plans or jobs. The log shipping plan will create a dedicated agent job that will schedule the transaction log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 10:34 am
do you have log backups running on this database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 10:31 am
New Born DBA (3/2/2015)
Restored with recovery
The secondary database must be restored with either NORECOVERY or STANDBY.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2015 at 9:26 am
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
Viewing 15 posts - 2,311 through 2,325 (of 9,244 total)