Viewing 15 posts - 2,026 through 2,040 (of 9,244 total)
hari.devadas 4119 (6/15/2015)
Yes, this would essentially P2V a single node cluster.my question would that work ?
No!!!
You're still not providing a definitive answer to my questions.
Do you want to end up...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2015 at 9:13 am
hari.devadas 4119 (6/12/2015)
Easy way to do this suggested by some was evicting the unwanted node
This will leave you with a single node cluster
hari.devadas 4119 (6/12/2015)
remove the cluster service
To remove clustering...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2015 at 8:43 am
Check the following
USE master
SELECT name FROM sys.symmetric_keys WHERE name LIKE '%DatabaseMasterKey%'
Assuming a DMK exists what password was used, check the encrypted state using this too
SELECT CASE is_master_key_encrypted_by_server
WHEN 0 THEN...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2015 at 8:37 am
P2ving a cluster is not my preferred route to be honest.
Which hypervisor are you using?
It sounds like you would like to drop the cluster for a standalone instance is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2015 at 8:36 am
to add further, despite this overhead, on 100+ databases the mirror traffic volume would still be my biggest worry. Unless you separate the mirror traffic you could be heading for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2015 at 4:31 am
check with your network admins as you'll likely need to grant specific permissions for the cluster CNO to create VCO's
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2015 at 4:28 am
hmm, I'm sure I tested this during my deployment. Ok at least that's cleared that up, thanks for the link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 10:00 am
Jacob Wilkins (6/11/2015)
No row versions, but 14-byte overhead
Where are you seeing this, which link?
It's very easy to test, setup a group with a readable secondary and no RCSI on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 8:39 am
Yep, if you pull the plug suddenly on both nodes the cluster should go offline as it wont have chance to recalculate the dynamic votes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 7:47 am
to install and patch a new node to a sql 2005 cluster requires the following steps
from active node run sql server setup via add\remove...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 7:45 am
TheSQLGuru (6/11/2015)
You can consider AO as glorified mirroring from a low-level functionality perspective.
Mirroring on steroids I tend to call it 😀
TheSQLGuru (6/11/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 7:29 am
you're welcome.
Please also read my stairway to HA starting at this link
http://www.sqlservercentral.com/articles/FCI/107536/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 5:32 am
DBANewbie (6/11/2015)
we have configured the quorum so that all 3 nodes have a vote (no file share witness as we already have an odd number of nodes).
Sounds reasonable
DBANewbie (6/11/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 4:45 am
phani404 (6/10/2015)
This is regarding log shipping.
I have verified log shipping status in one of my servers.
Backup, copy, restore jobs are running successfully, I didn't find any errors.
also verified...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 4:38 am
dba 11727 (6/11/2015)
he noted that it was unusual to have a Quorum group explicitly created under the Services and Applications node and thought that this might cause a problem.
Yep, almost...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 4:36 am
Viewing 15 posts - 2,026 through 2,040 (of 9,244 total)