Blog

Hello all. I manage 50+ minisites (all static) spread over 4 reseller accounts with 4 different hosting companies. The DNS is hosted separat… | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1828202&goto=newpostRead more

In the book Pro SQL Server Always On Availability Groups They write about scalability. Here is what they say “Windows Server 2012 (and above), failover clustering supports up to 64 clulster nodes. This helps to easily scale out the solution by adding nodes to it. For example, if you have a two-node failover cluster hostingRead more

We have a 16 node SQL 2016 failover cluster with around 20 SQL instances and total number of databases around 600. Since we are upgrading our hardware to Hyper-Converged infrastructure which has limitations with failover clusters with shared disks then we have to migrate our cluster to availability groups. My question is: what should weRead more

I have 2 boxes running SQL 2016, and set up using Always On Availability. i have a listener set up to choose which server to talk to in case of a failover, which seems to work fine, except for the fact that i’m using mixed authentication, and my connection string is using a SQL authenticationRead more

Hi guys We’d like to know what our options are for High Availability Failover services or services with dual availability zones where we … | Read the rest of http://www.webhostingtalk.com/showthread.php?t=1691284&goto=newpostRead more

Hi, i use centos to setup samba for windows server to access, but it is install on only one dedicated server now, i want to ask if any go… | Read the rest of http://www.webhostingtalk.com/showthread.php?t=1691211&goto=newpostRead more

I’d like to preface this by saying I’m not a DB admin nor have any formal training in DB administration, but trying to get an response in a reasonable time from our network team is like pulling teeth. Some of the terminology or usage of words might not be exact, but hopefully I’m getting itRead more

Our SP2010 farm have 1 SQL server (sql01). Recently we setup another sql server (sql02) with SQL mirroring. I follow this blog post to setup failover server for each database (including system db and content db) with PowerShell. Later I found several service application also have “Failover Database Server” settings. For example, managed metadata andRead more

I have set up a SQL Server 2016 Standard cluster (Cluster-SQL) on node 1 (Cluster-Node-1) which is appearing in Windows Failover Cluster manager without issue. When I attempt to add a second node (Cluster-Node-2) to this cluster and I reach the Cluster Node Configuration, there is no SQL Server instance name listed or available fromRead more

I have 2 nodes-cluster SQL Server Standard 2016 with Failover clustering configured with Dynamic quorum. There is one thing that made me confused: Do we really need “witness” in this case? Since i enabled Dynamic quorum, my cluster will not go down if one of the nodes go down. But some guys said, for theRead more