Failover Cluster Manager Tool

You can access the Failover Cluster Management in a couple of different ways: Go to Server Manager, Features, Failover Cluster Manager Go to Control Panel, Administrative Tools, Failover Cluster Manager Sources: https://www.mssqltips.com/sqlservertip/2672/managing-a-windows-and-sql-server-cluster-using-the-failover-cluster-manager-tool/

SQL Server 2008 High Availability Options

There are 4 High Availability options in SQL Server 2008 that we will cover; Failover Clustering, Database Mirroring, Log Shipping and Replication. Each one has its own features and benefits. The Failover Clustering supports server level high availability whereas Database Mirroring and Log Shipping are per database and Replication is object level.  Failover Clustering This... » read more

SQL Server Managmenet Studio 18 (SSMS)

Install https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 SSMS 18.4 is the latest general availability (GA) version of SSMS. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.4 upgrades it to 18.4. The SSMS 18.x installation doesn’t upgrade or replace SSMS versions 17.x or earlier. SSMS 18.x installs side by side with previous versions, so both... » read more

Always On Availability Group – Select Data Synchronization

Select “Automatic seeding” (default) if you have not created the database on the secondary replica and would like this wizard to create the database on the secondary replica based on the same setting as the primary replica. Use this option, if this is a small database. Select “Join only” if you already have already created... » read more

Upgrading SQL Server 2014 via Uninstall/Re-install

Process Detach databases. Uninstall SQL Server 2014 Install SQL Server 2016/2019 Reattach databases. Uninstall SQL Server 2014 (v12) To uninstall SQL Server instance, go to Control Panel and then Programs and Features. Select and right-click on Microsoft SQL Server 2014 and select Uninstall/remove. Upgrade to SQL Server 2016 (v13) SSMS Tool https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Upgrade to SQL... » read more