High Availability (HA)

SQLServerCentral Article

Basic Always On Availability Groups in SQL Server Standard

  • Article

Once Windows Server Failover Clusters have been set up, we can set up Availability Groups in SQL Server. This article will focus on setting up Basic Always-On Availability Groups in SQL Server Standard Edition.
This facilitates High Availability in SQL Server Standard, with three levels of availability and failover:
Asynchronous commit with manual or forced failover,
Synchronous commit with manual or forced failover,
Synchronous commit with automatic failover.

5 (3)

You rated this post out of 5. Change rating

2024-06-05

1,216 reads

SQLServerCentral Article

Add a Second NIC for an Availability Group to Separate Network Traffic

  • Article

Introduction Sometimes we face the scenario in an enterprise environment that the database in SQL Server Always On Availability Group (AOAG) has high concurrency read and write access from application servers. If we keep using the one network interface card for both network traffic of database connections from application servers and database mirroring between AOAG […]

4.75 (4)

You rated this post out of 5. Change rating

2023-05-08

2,925 reads

Technical Article

Always On Availability Groups Troubleshooting and Monitoring Guide

  • Article

This guide helps you get started on troubleshooting some of the common issues in AlwaysOn Availability Groups and monitoring AlwaysOn Availability Groups. It is intended to provide original content as well as a landing page of useful information that is already published elsewhere.

You rated this post out of 5. Change rating

2024-01-09 (first published: )

Blogs

Speaking at SQL Saturday South Florida 2024

By

I’m heading to SQL Saturday South Florida 2024 next week. This is my second...

The Next Phase & A Fresh Start

By

As of June 1, I am no longer an employee at 3Cloud. I am...

How do you restore a SQL Server 2000 database in the year 2024?

By

A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I...

Read the latest Blogs

Forums

Cannot Force Encryption - SQL Will Not Take Cert

By amy26

Hi there, I have a sql server on government AWS and we're trying to...

SHOWPLAN documentation

By as_1234

The most recent documentation I can find is this https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms189602(v=sql.105) which is showing as...

SSIS task that runs a PowerQuery

By pietlinden

I already have a PowerQuery that reads and parses a table from a PDF...

Visit the forum

Question of the Day

Dropping a Logon Trigger

I created this trigger for testing on SQL Server 2022:

CREATE TRIGGER checksteve
ON ALL SERVER 
FOR LOGON  
AS  
BEGIN  
IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve'
 PRINT 'Steve logged in'
END;  
GO
Now I want to drop it. What do I run?

See possible answers