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

Content with tag Availability Group (AG) Rss

   Items 1 to 20 of 47    Older >>
 

Building an AG

By Steve Jones 2018/11/15 | Category: availability group (ag)
Rating: (not yet rated) |  Discuss |   Briefcase | 631 reads

AlwaysOn AG Dashboard

By Henrico Bekker 2018/07/16 | Category: availability group (ag)
Rating: (not yet rated) |  Discuss |   Briefcase | 656 reads

The BAG Secondary

By Steve Jones 2018/06/11 | Category: availability group (ag)
Rating: (not yet rated) |  Discuss |   Briefcase | 745 reads

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 | 507 reads

Automatic Page Repair

By Steve Jones 2018/03/26 | Category: automatic page repair
Rating: (not yet rated) |  Discuss |   Briefcase | 713 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 | 577 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 | 709 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,326 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,960 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 | 979 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,219 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 | 773 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,665 reads

Add new Databases to a AG Setup with PowerShell

Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 222 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 | 4,033 reads

AG Sync Folders

By Steve Jones 2017/07/24 | Category: availability group (ag)
Rating: (not yet rated) |  Discuss |   Briefcase | 858 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 | 317 reads

AlwaysON Availability Group and Jobs Part 2

This article will provide the actual implementation of the control mechanism.  Read more...
Rating: |  Discuss |   Briefcase | 933 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 | 954 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,697 reads
   Items 1 to 20 of 47    Older >>
 
Tags
always on (22)    
high availability (ha) (15)    
backup (4)    
sql server 2016 (3)    
administration (2)    
agent jobs (2)    
azure (2)    
encryption (2)    
failover (2)    
powershell (2)    
sql server 2012 (2)    
tde (2)    
applicationintent (1)    
automatic database seeding (1)    
automatic databases seeding (1)    
automatic page repair (1)    
automatic seeding (1)    
availability (1)    
availability database (1)    
availability group listener (1)    
backup and restore (1)    
blogs (1)    
certificates (1)    
clustering (1)    
data protection (1)    
database mirroring (1)    
decryption (1)    
distributed availability groups (1)    
execution plans (1)    
gmsa (1)    
group managed service accounts (1)    
groups (1)    
log shipping (1)    
mssql (1)    
netbackup (1)    
read only routing (1)    
read-only (1)    
replica (1)    
routing (1)    
service packs (1)    
sql server (1)    
sql server 2014 (1)    
sql server 2017 (1)    
sql server on linux (1)    
sql2016 (1)    
veritas netbackup (1)    
waits and queues (1)    
windows cluster (1)