From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Create additional SQL Server instances

Create additional SQL Server instances - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Create additional SQL Server instances

“

- [Instructor] In a production environment it's rare to find a single instance of SQL Server working by itself on a single computer. Usually, there are multiple systems in place for increased redundancy and enhanced performance. When it comes to managing multiple computers, there are a couple of technologies that you should be familiar with. First is a method to link several computers together to provide a level of fault tolerance to the hardware. When uptime is critical, turn to a clustered server configuration. Clustered instances allow multiple physical machines to get linked together and act as a single machine. When SQL Server is installed to take advantage of a clustered server, if one machine loses network connection, or otherwise gets taken offline through some sort of failure of the hardware, the other machine is right there, ready to pick up the slack. SQL Server will switch over to the other computer with minimal downtime during the transfer. Clustered instances will use…

Contents