Changin SQL replication Distributon Default Folder - SQL 2016

Mark Gordon 926 Reputation points
2022-12-19T17:19:10.37+00:00

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
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PandaPan-MSFT 1,931 Reputation points
    2022-12-21T02:43:21.767+00:00

    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 .
    272675-image.png

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.