This topic has not yet been rated - Rate this topic

Snapshot Options

SQL Server 2008

Other Versions

There are a number of options available when initializing a subscription with a snapshot:

Specify an alternate snapshot folder location instead of or in addition to the default snapshot folder location. For more information, see Alternate Snapshot Folder Locations.
Compress snapshots for storage on removable media or for transfer over a slow network. For more information, see Compressed Snapshots.
Execute Transact-SQL scripts before or after the snapshot is applied. For more information, see Executing Scripts Before and After the Snapshot Is Applied.
Transfer snapshot files using File Transfer Protocol (FTP). For more information, see Transferring Snapshots Through FTP.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions