CopySubscription Method (Replication ActiveX)

The CopySubscription method copies the entire subscription database to the file location specified by the parameter.

Important

Support for initializing a subscription by copying and attaching an existing subscription database has been deprecated.

Syntax

object.CopySubscription filespec
Part Description

object

Expression that evaluates to an object in the Applies To list.

filespec

File name and path to which subscription database is copied.

Applies To

SQLDistribution Object (Replication ActiveX)

SQLMerge Object (Replication ActiveX)

Remarks

CopySubscription copies a specially prepared database subscription file (typically with an .msf extension), which can be used to initialize a subscription at another Subscriber without applying an initial snapshot. Use the AddSubscription Method (Replication ActiveX) method with the ATTACH_SUBSCRIPTION option to create the new subscription from the .msf file.

You can use the CopySubscription method to copy a subscription database that contains more than one subscription.

Prototype (C/C++)

HRESULT CopySubscription(BSTR bstrSubscriptionFileName);

See Also

Reference

DropSubscription Method (Replication ActiveX)

Help and Information

Getting SQL Server 2005 Assistance