Zoftcorp Logo
Back to All Blogs
Database AdministrationBLOG POST

How Zoftcorp Ease Your Failover Cluster Installation with Slipstream

Feb 12, 2024
3 min read
By admin
How Zoftcorp Ease Your Failover Cluster Installation with Slipstream
ARTICLE SUMMARY

Home What is Slipstream? Slipstream means embedded installation of SQL server with the available service packs, cumulative updates or Hotfixes. This technology is introduced in SQL Server 2008 and it saves the time of DBA...

What is Slipstream?

Slipstream means embedded installation of SQL server with the available service packs, cumulative updates or Hotfixes. This technology is introduced in SQL Server 2008 and it saves the time of DBA.

Traditionally, database administrators were required to first install the base RTM version of SQL Server and then separately apply Cumulative Updates (CUs) or Service Packs. In a Windows Server Failover Cluster (WSFC) environment, this process multiplied maintenance windows and increased potential reboot cycles across each cluster node. Slipstream integration simplifies this by injecting the patch bits directly into the initial cluster deployment routine.

5 Simple steps to do Failover cluster Slipstream Installation:

  1. 1

    Mount the ISO image of the SQL Server Installer

    Mount the SQL Server installation media (ISO image) on the primary cluster node where you plan to execute the setup routines.

  2. 2

    Copy the mounted SQL Files to any of the folder

    In this case SQL exe files are placed in C:\SQL\SQL2016\

  3. 3

    Create folder named “Updates” and copy the Service packs

    Create folder named “Updates” and copy the Service packs, Cumulative updates or Hotfixes. For ease I created the folder under C:\SQL\SQL2016\Updates

  4. 4

    Use the below command to Install a Failover cluster

    Command Prompt // Install Failover Cluster with Slipstream
    cmd
    C:\SQL\SQL2016>setup.exe /Action=InstallFailovercluster /UpdateEnabled=True /UpdateSource="C:\SQL\SQL2016\Updates"
    SlipstreamFCI command execution
  5. 5

    Use the below command to add a cluster Node with Slipstream Installation

    Command Prompt // Add Cluster Node with Slipstream
    cmd
    C:\SQL\SQL2016>setup.exe /Action=Addnode /UpdateEnabled=True /UpdateSource="C:\SQL\SQL2016\Updates"
    SlipstreamFCI2 command execution
GUI Installation Completion

After executing the command, the GUI option will pop-up and can do normal FCI installation.

EXPERT CONSULTATION // ZOFTCORP SERVICES

Looking for a Reliable Database Partner?

If you are looking for a reliable and professional partner to help you migrate your database to the cloud, look no further than Zoftcorp. Contact us today to get a free consultation and quote for your database migration project at contact@zoftcorp.com.