Share via


TransSubscription.BackupInformation Property

Definition

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

public:
 property Microsoft::SqlServer::Replication::SubscriptionBackupInformation ^ BackupInformation { Microsoft::SqlServer::Replication::SubscriptionBackupInformation ^ get(); void set(Microsoft::SqlServer::Replication::SubscriptionBackupInformation ^ value); };
public Microsoft.SqlServer.Replication.SubscriptionBackupInformation BackupInformation { get; set; }
member this.BackupInformation : Microsoft.SqlServer.Replication.SubscriptionBackupInformation with get, set
Public Property BackupInformation As SubscriptionBackupInformation

Property Value

A SubscriptionBackupInformation object.

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).

Applies to