Alternate Snapshot Folder Locations
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Alternate snapshot locations enable you to store snapshot files in a location other than, or in addition to, the default location, which is typically located on the Distributor. Alternate locations can be on another server, on a network drive, or on removable media such as CD-ROMs or removable disks.
Alternate snapshot locations are stored as a property of the publication. Because the alternate snapshot location is a publication property, the Distribution Agent and the Merge Agent are able to locate the proper snapshot as part of the synchronization process.
If you want to specify an alternate snapshot folder location or if you want to compress snapshot files, create the publication without creating the initial snapshot immediately, set the publication properties for the snapshot location, and then run the Snapshot Agent for that publication. If you change the alternate location after creating the initial snapshot, the location of any generated snapshot for the publication will not be relocated to the new alternate location. In this case, depending on the publication settings, the Merge Agent or Distribution Agent might not be able to find the snapshot files at the new alternate location.
Do not specify an alternate location (using the Publication Properties dialog box or sp_changepublication (Transact-SQL)) that is the same as the default snapshot folder location.
Do not use both WebSync and alternate snapshot folder locations at the same time.
To specify alternate snapshot locations
SQL Server Management Studio: Specify an Alternate Snapshot Folder Location (SQL Server Management Studio)
Replication Transact-SQL programming: Configure Snapshot Properties (Replication Transact-SQL Programming)