sys.sp_copysubscription

Description

Copies a subscription database that’s pull subscriptions, but no push subscriptions. Only single file databases can be copied. This stored procedure is executed at the Subscriber on the The string that specifies the complete path, including file name, to which a copy of the data file This feature will be removed in a future version of SQL Server.

Syntax

sp_copysubscription
[ @filename = ]
N
'filename'
[ , [ @temp_dir = ]
N
'temp_dir'
]
[ , [ @overwrite_existing_file = ] overwrite_existing_file ]
[ ; ]