Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [snapshot-replication]

11 questions
3
votes
2 answers

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 Subscriber of Server 2 runs on Server 1 (where the…
J.D.
  • 40,776
  • 12
  • 62
  • 141
2
votes
0 answers

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 & immediate_sync are set to false by default. I…
Sowjanya Ravi
  • 21
  • 1
2
votes
2 answers

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 production so that queries are not hitting the live…
LearnByReading
  • 711
  • 10
  • 26
1
vote
0 answers

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.516 Category: NULL Source: Microsoft OLE DB…
V N
  • 11
  • 2
0
votes
0 answers

Snapshot replication taking too long for large database using SQL Server Management Studio

I have a 70 GB loaded SQL database and need to perform snapshot replication. I created the publisher and started the snapshot agent, but it takes very long Even after 5 hours, the process did not generate an unc snapshort. Then I removed the…
Mr doubt
  • 101
  • 2
0
votes
1 answer

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 from the last 1 year are added to the dev…
Merve
  • 57
  • 7
0
votes
1 answer

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 position and file. I then take a LVM snapshot, and then…
basedrum1
  • 21
  • 5
0
votes
1 answer

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 another PREPROD database "myDB2". The problem is that the transactional…
jpprade
  • 145
  • 4
0
votes
1 answer

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 that has to be done manually either with transact…
Charlie
  • 1
  • 2
0
votes
0 answers

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 manually run the snapshots. In the past, we have been…
James
  • 1
  • 1
0
votes
0 answers

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: 53. Update : I fixed this error by setting up the…
Ajeesh Joshy
  • 101
  • 1