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).
The Snapshot page of the Publication Properties dialog box allows you to set the snapshot format, snapshot folder location, and scripts to run before and after the application of the snapshot. The snapshot folder must be designated as a share and have sufficient permissions for the agents that read and write files to the folder. For more information about securing the folder appropriately, see Secure the Snapshot Folder.
Select native mode or character mode for the snapshot format.
Select Native SQL Server - all Subscribers must be servers running SQL Server if all Subscribers are instances of Microsoft SQL Server other than Microsoft SQL Server Compact. The native snapshot format provides the best performance.
Select Character - required if a Publisher or Subscriber is not running SQL Server if any Subscribers are running SQL Server Compact or are non-SQL Server Subscribers.
Location of snapshot files
Select the location to store snapshot files. They can be stored in the default location; they can also be stored in an alternate location instead of, or in addition to, the default location. Files stored in an alternate location can be compressed.
Select Put files in the default folder to use the default snapshot folder for the Publisher. The snapshot folder location is read-only in this dialog box, because it can only be changed for the Publisher in the Distributor Properties dialog box. For more information, see Specify the Default Snapshot Location (SQL Server Management Studio).
Select Put files in the following folder to specify an alternate location instead of, or in addition to, the default location. Enter a path in the text box or click Browse and navigate to a location. Select Compress snapshot files in this folder to compress the files in the alternate snapshot location. The alternate location can be on another server, on a network drive, or on removable media such as a CD-ROM or removable disk. For more information, see Alternate Snapshot Folder Locations and Compressed Snapshots.
Run additional scripts
Specify scripts to be executed before and after the snapshot is applied at the Subscriber. Scripts cannot be specified if Snapshot format is Character.