Viewing 15 posts - 2,026 through 2,040 (of 9,241 total)
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
AlwaysOn offers the ability to have multiple readonly replicas, failover is now managed by the WSFC subsystem and can incorporate the inclusion of a TCP IP listener. Aside this the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 4:16 am
FT catalog storage changed between SQL server 2005 and 2008, please see this link
https://msdn.microsoft.com/en-us/library/ms142490.aspx#Attaching_2005_ft_catalogs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 4:11 am
i1888 (6/10/2015)
Clustered role 'XXXRole' has exceeded its failover threshold. It has exhausted the configured number of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2015 at 4:02 am
Viewing 15 posts - 2,026 through 2,040 (of 9,241 total)