Sql-server – SQL Server secondary replica snapshot with Basic Availability Group

availability-groupssnapshotsql serversql-server-2016standard-edition

I have the following scenario:

I created an HA group of two nodes in SQL Server 2016 Standard (which is limited to two nodes, one database per group and a non readable secondary replica).
I tried to take a snapshot of the secondary non-readable replica, but it's didn't work and I can do that only on primary replica.

On failover snapshot replication (local publication) is moving automatically on primary replica.

From what I read it's possible to have a snapshot on secondary non-readable replica.

What am I doing wrong?

Best Answer

That link refers to taking a Database Snapshot of the secondary database, which was possible in Database Mirroring.

Remember there are lots of unrelated things that use the word "snapshot" in SQL Server:

Database snapshots are unrelated to snapshot backups, snapshot isolation of transactions, or snapshot replication.

It's not possible to use a Snapshot Replication with a secondary database:

In an availability group a secondary database cannot be a publisher. Republishing is only supported when transactional replication is combined with Always On availability groups.

Replication, change tracking, & change data capture - Always On availability groups

Related Question