Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

What's SQL Failover Cluster Instance

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

What's SQL Failover Cluster Instance

Postby chicagotech » Wed Aug 23, 2017 4:04 pm

An SQL Failover Cluster Instance runs in a Windows Server Failover C lustering resource group with one or more WSFC nodes. When the FCI starts up, one of the nodes assume ownership of the resource group and brings its SQL Server instance online. The resources owned by this node could be Network name, IP address, Shared disks, SQL Server Database Engine service, SQL Server Agent service, SQL Server Analysis Services service, One file share resource.

At any time, only the resource group owner (and no other node in the FCI) is running its respective SQL Server services in the resource group. A failover could be an automatic failover or a planned failover.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 7064
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 5 guests