Questions tagged [snapshot-replication]
The snapshot-replication tag has no usage guidance.
6
questions
0
votes
1
answer
41
views
SQL server replication conflicts
Once per week, a snapshot publication is done from a database "myDB" in PROD to "myDB" in PREPROD.
Now in PREPROD we set up a transactional replication between "myDB" to ...
- 145
0
votes
1
answer
141
views
Deleting old snapshots SQL
This may be a silly or dumb question but...
We just changed the snapshot path and I was wondering if the cleanup job also clears up the old snapshots from the previous folder path or is it something ...
- 1
0
votes
0
answers
43
views
Why can I not manually run more than one snapshot agent at a time
My organization has a SQL Server 2016 instance with multiple databases, and multiple publications/subscriptions for each database, in a transactional replication set-up.
Occasionally, we need to ...
- 1
2
votes
2
answers
124
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 ...
- 701
3
votes
2
answers
534
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 ...
- 25.6k
0
votes
0
answers
380
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: ...
- 101