sys.sp_copysnapshot

Description

Copies the snapshot folder of the specified publication to the folder listed in the. This stored procedure is executed at the Publisher on the publication database. This stored procedure is useful for copying a snapshot to removable media.

Syntax

sp_copysnapshot
[ @publication = ]
N
'publication'
, [ @destination_folder = ]
N
'destination_folder'
[ , [ @subscriber = ]
N
'subscriber'
]
[ , [ @subscriber_db = ]
N
'subscriber_db'
]
[ , [ @publisher = ]
N
'publisher'
]
[ ; ]