Questions tagged [snapshot-replication]
The snapshot-replication tag has no usage guidance.
4
questions
2
votes
2answers
73 views
SQL Server replication methodology
I have a relatively large production environment (150GB) in SQL Server, and I need to duplicate it somewhere else for querying (specifically: I need to create an environment identical to the ...
3
votes
2answers
187 views
Pre- and Post- Snapshot Replication Scripts Not Executing and No Errors
I have a Snapshot Replication Publication setup on Server 1.
Server 2 subscribes to the publication on Server 1.
Data is replicating successfully.
The Distributor Agent and Agent job for the ...
0
votes
0answers
152 views
SQL Server Snapshot replication - Failing to start the Publisher snapshot agent
I am trying to set up a Snapshot replication using an Azure SQL Managed Instance. While trying to see the Snapshot Agent status, I see this error. Failed to connect to Azure Storage '' with OS error: ...
0
votes
0answers
79 views
Cleaning replication tables before snapshot applied to subscriber
We have a snapshot replication setup.
In some cases (like previous replications failed etc), some subscribers get the following error
The ALTER TABLE statement conflicted with the FOREIGN KEY ...
