Поделиться через


Свойство CopyOnly

Gets or sets a Boolean property value that specifies the backup is a copy-only backup. This does not affect the sequence of backups in the usual backup schedule.

Пространство имен:  Microsoft.SqlServer.Management.Smo
Сборка:  Microsoft.SqlServer.SmoExtended (в Microsoft.SqlServer.SmoExtended.dll)

Синтаксис

'Декларация
Public Property CopyOnly As Boolean
    Get
    Set
'Применение
Dim instance As Backup
Dim value As Boolean

value = instance.CopyOnly

instance.CopyOnly = value
public bool CopyOnly { get; set; }
public:
property bool CopyOnly {
    bool get ();
    void set (bool value);
}
member CopyOnly : bool with get, set
function get CopyOnly () : boolean
function set CopyOnly (value : boolean)

Значение свойства

Тип System. . :: . .Boolean
A Boolean value that specifies whether the backup is a copy-only backup.
If True, the backup is a copy-only backup.
If False (default), the backup is not a copy-only backup, and is part of the usual sequence of backups.

Замечания

A copy-only backup does not affect your overall backup and restore procedures for the database.

Copy-only backups were introduced in SQL Server 2005 for use in situations in which a backup is taken for a special purpose, such as backing up the log before an online file restore. Typically, a copy-only log backup is used one time and then deleted.