• Article

TransSubscription.BackupInformation Property

Gets or sets information needed to initialize a subscription from a backup.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Property BackupInformation As SubscriptionBackupInformation
    Get
    Set
'Usage
Dim instance As TransSubscription
Dim value As SubscriptionBackupInformation

value = instance.BackupInformation

instance.BackupInformation = value

public SubscriptionBackupInformation BackupInformation { get; set; }

public:
property SubscriptionBackupInformation^ BackupInformation {
    SubscriptionBackupInformation^ get ();
    void set (SubscriptionBackupInformation^ value);
}

member BackupInformation : SubscriptionBackupInformation with get, set

function get BackupInformation () : SubscriptionBackupInformation
function set BackupInformation (value : SubscriptionBackupInformation)

Remarks

You must enable AllowInitializationFromBackup on the Attributes property for the publication before you set the BackupInformation property.

The BackupInformation property value is ignored if the value SyncType is not InitializeWithBackup.

The BackupInformation property is a read/write property that cannot be accessed once the subscription has been created.

The BackupInformation property can only be set by members of the sysadmin fixed server role or by members of the db_owner fixed database role.

Setting BackupInformation is equivalent to executing sp_addsubscription (Transact-SQL).

The BackupInformation property is available with SQL Server 2005 only.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.