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)
Property Value
Type: Microsoft.SqlServer.Replication.SubscriptionBackupInformation
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).
See Also
Reference
Microsoft.SqlServer.Replication Namespace