Hi @Mark Gordon ,
The Snapshot Agent takes a snapshot of a transient state of the database and sends the snapshot to the Subscriber. Because snapshot files are typically large, snapshot replication takes longer to synchronize data. And because snapshots are static, replication does not automatically deliver data changes to Subscribers, which means the snapshot is saved on the server. I tested the situation on my VM and it seems no problem to me .
Changin SQL replication Distributon Default Folder - SQL 2016
Fellow DBA's,
I am going to need to change the default snapshot location on the distributor.
1 - All we run is transactional.
2 - I am seeing some info that to me is confusing about what I need to do after this simple change. It is my understanding that this folder is not used for anything other than creating a snapshot/initialization.
After I make the change, am I supposed to run a snapshot but not initialize the db for some type of resync? Reference is
https://www.mssqltips.com/sqlservertip/2785/changing-sql-servers-default-snapshot-folder-for-replication/
Thanks
MG
SQL Server | Other
1 answer
Sort by: Most helpful
-
PandaPan-MSFT 1,931 Reputation points2022-12-21T02:43:21.767+00:00