SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Availability Group (AG) Rss

Search for any content tagged availability group (ag)

   Items 1 to 20 of 27    Older >>
 

SQL Server 2016 Availability Group - Automatic Seeding with SSMS 17.x

In SQL Server 2016 the availability group automatic seeding functionality is implemented. This article will detail the steps to use of SSMS with automatic seeding and its limitations.  Read more...
By PremKumar Raju 2018/03/27 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 495 reads

TDE with Automatic Database Seeding

Transparent Data Encryption on an Availability Group and Automatic Database Seeding  Read more...
By Evgeny Garaev 2018/03/08 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 574 reads

Configure Read Only Routing

The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.   Read more...
By Ganapathi varma Chekuri 2018/02/05 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 676 reads

Add a SQL Server Database to an Existing Always On Availability Group

In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.  Read more...
By Additional Articles 2018/02/05 | Source: MSSQLTips.com | Category: availability group (ag)
Rating: (not yet rated)  Rate this |   Briefcase | 2,240 reads

Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3

In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.  Read more...
By Additional Articles 2018/02/02 | Source: MSSQLTips.com | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 2,858 reads

Automatic Database Seeding

Set up and use the automatic databases seeding feature for Availability Groups.  Read more...
By Evgeny Garaev 2018/01/22 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 963 reads

SQL Server AlwaysOn Availability Groups Using an Azure Template

There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.  Read more...
By Additional Articles 2017/10/18 | Source: MSSQLTips.com | Category: availability group (ag)
Rating: (not yet rated)  Rate this |   Briefcase | 3,126 reads

Group Managed Service Accounts (gMSAs) in SQL2016

Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON  Read more...
Rating: |  Discuss |   Briefcase | 744 reads

Network Configuration of SQL Server Always On Availability Groups in Azure

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, Marcin Policht looks at the networking aspects of clustered deployments of SQL Server 2016 in Azure.  Read more...
By Additional Articles 2017/10/11 | Source: Database Journal | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 2,598 reads

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.  Read more...
By Additional Articles 2017/09/08 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,935 reads

Configuring Backups Using Veritas Netbackup with AGs

A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.   Read more...
By Kenneth Igiri 2017/07/18 | Source: SQLServerCentral.com | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 315 reads

AlwaysON Availability Group and Jobs Part 2

This article will provide the actual implementation of the control mechanism.  Read more...
Rating: |  Discuss |   Briefcase | 917 reads

AlwaysON Availability Group and Jobs Part 1

In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios.   Read more...
Rating: |  Discuss |   Briefcase | 910 reads

Office Hours Webcast 2017/02/01

In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.  Read more...
By Additional Articles 2017/02/14 | Source: Brent Ozar Unlimited Blog | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 3,611 reads

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.  Read more...
By Additional Articles 2017/01/13 | Source: MSSQLTips.com | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 3,165 reads

Resolving an Error When Creating an Availability Group Listener

In this post, I’m going to talk an issue that I found when creating an availability group listener by using SQL Server Management Studio's Add Listener. This article helps you to resolve the issue.   Read more...
By Ganapathi varma Chekuri 2016/09/06 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 828 reads

SQL Server 2016 : Availability Group Enhancements

Aaron Bertrand reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 6,736 reads

Read-Only Routing for Non-Microsoft Clients

An alternative read-only routing technique for non-Microsoft clients.  Read more...
By Chad Feghali 2015/12/28 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 2,148 reads

Monitoring Availability Group Replica Synchronization

If you are deploying SQL Server Availability Groups, one of the important aspects of a successful deployment is monitoring the synchronization of the secondary replica databases with the primary replica - but there are multiple ways to do this. Jonathan Kehayias goes through each, explaining their different benefits and drawbacks.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,694 reads

AlwaysOn in SQL Server 2014 CTP1

AlwaysOn encompasses the SQL Server solutions for mission-critical high availability and disaster recovery. Two solutions were included under the AlwaysOn umbrella in SQL Server 2012: Availability Groups and Failover Cluster Instances. Each solution has different characteristics, making them appropriate for different scenarios, and both can be combined in the same deployment.  Read more...
By Additional Articles 2013/07/25 | Source: MSDN Communities | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 2,776 reads
   Items 1 to 20 of 27    Older >>