You can create a single-database AG in each cluster (Primary only, no secondaries) and the create an AG on top of that between the two clusters. The 'AG-of-AGs' is called...

This is a great excuse to write a recursive query 🙂

DECLARE @InputDate datetime;
DECLARE @InputYear smallint, @EndYear smallint;

-- test date:
SELECT @InputDate = '2011-05-04', @EndYear = YEAR(getdate());

-- Fun with...

There's a link to the SQL 2017 Licensing Guide at https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing

Pages 26-29 of that guide cover HA licensing, including this line on p.27:

For each server licensed with SQL Server 2017...

during the period where the endpoint was one stop can I have lost data?

You will not lose data when the Primary Replica cannot communicate with a Secondary Replica. The Primary...

FCI + AG is supported. We're running many FCI+AG clusters in production.

The error message is informing you that an AG with at least one replica hosted on an FCI instance...

+1 for Lowell's comments that the expiring lab OS can be a driver for learning the Powershell and command-line install steps to re-build a domain and some clusters. Home labs...

Go to https://www.microsoft.com/en-us/learning/browse-all-certifications.aspx

Under "Filter Role-based certifications by technology or job role", click the 'Technology" box and select 'SQL Server'.

The current certs will be shown.

MTA: Base certification, single test....

A database backup carries no details about any mirroring or AG configuration.

Leave your current mirroring in place. Any backup you take (or have already taken) of a mirrored database may...

The simplest (but not the most efficient) way is to just crawl up the nodes with ../ to move up each level

select
  a.Server, a.[Report],
  Hyperlink...

AGs in two different clusters can be connected into a Distributed Availability Group (https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-2016), which will provide you with AG-to-AG (in your case, site-to-site) replication. When using Distributed...

Use a single-quote twice.

SELECT 'Men''s Large' AS [Result]

You need to update the secondary server first. SQL Server 2012 cannot read transaction log backups from SQL2014 or later.

https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/upgrading-log-shipping-to-sql-server-2016-transact-sql?view=sql-server-2016

The optimizer does not respect your join order unless you force it (which is usually the wrong thing to do). Based on the JOIN conditions and the filters in the...

I was happy to see that I don't need to turn that off every time I post.

You must execute that ALTER statement in the context of the database that contains the object.

When calling an object over a linked server, you must use a four-part name:

[1...

• This reply was modified 5 years, 8 months ago by  Eddie Wuerch.
• This reply was modified 5 years, 8 months ago by  Eddie Wuerch.