Questions tagged [snapshot-replication]
The snapshot-replication tag has no usage guidance.
10
questions
1
vote
0
answers
42
views
Snapshot replication fails with error 4817
I have set up snapshot replications between two SQL Servers. There are multiple replication jobs, one for each database. One of subscriber jobs is failing with the error message
2024-07-29 06:05:55....
- 11
0
votes
1
answer
40
views
Records in the dev environment were deleted due to filter in SQL Server replication
I want to create replication in SQL Server and move the records that have changed in the last year to the test environment. Since I added a filter for last 1 year, when replication runs, only records ...
- 57
2
votes
0
answers
137
views
Transactional replication not replicating with 'The process is running and is waiting for a response from the server' error after adding new article
I have a Transactional Replication setup which has been working fine for a long time. It is a Pull Subscription. I got a new requirement to replicate a large article which is 10GB.
allow_anonymous &...
0
votes
1
answer
315
views
LVM snapshot of MyISAM tables requires repair every time
I'm attempting to setup slave replication of a large MyISAM table. I login to the master server and perform FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS and that returns right away with the ...
- 21
0
votes
1
answer
730
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
1k
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
175
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
199
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 ...
- 711
3
votes
2
answers
1k
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 ...
- 38.6k
0
votes
0
answers
758
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