TransSubscription.BackupInformation Property

  • Article

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

public SubscriptionBackupInformation BackupInformation { get; set; }

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

/** @property */
public SubscriptionBackupInformation get_BackupInformation ()

/** @property */
public void set_BackupInformation (SubscriptionBackupInformation value)

public function get BackupInformation () : SubscriptionBackupInformation

public function set BackupInformation (value : 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).

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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

TransSubscription Class
TransSubscription Members
Microsoft.SqlServer.Replication Namespace

Other Resources

Initializing a Transactional Subscription Without a Snapshot