Export (0) Print
Expand All

Alternate Snapshot Folder Locations

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.

Subscribers running versions of Microsoft SQL Server earlier than SQL Server 2000 cannot use the alternate snapshot location. Therefore, continue to use the default snapshot location to store snapshot files for those Subscribers.

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.

ms151327.note(en-US,SQL.90).gifNote:
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.

To specify alternate snapshot locations

Community Additions

ADD
Show:
© 2014 Microsoft