Partager via

  • Article

Propriété BackupInformation

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

Espace de noms :  Microsoft.SqlServer.Replication
Assembly :  Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)

Syntaxe

'Déclaration
Public Property BackupInformation As SubscriptionBackupInformation
    Get
    Set
'Utilisation
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)

Notes

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.