Class DatabasesAndFilesSchema.BackupDevice

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.backup_devices (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains a row for each backup-device registered by using sp_addumpdevice or created in SQL Server Management Studio.

See sys.backup_devices.

[Table(Schema = "sys", Name = "backup_devices", IsView = true)]
public class DatabasesAndFilesSchema.BackupDevice

Inheritance

object

DatabasesAndFilesSchema.BackupDevice

Extension Methods

Map.DeepCopy<T>(T)

Properties

Name

Name of the backup device. Is unique in the set.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

PhysicalName

Physical file name or path of the backup device.

[Column("physical_name")]
[Nullable]
public string? PhysicalName { get; set; }

Property Value

string

TypeColumn

Type of backup device:

2 = Disk

3 = Diskette (obsolete)

5 = Tape

6 = Pipe (obsolete)

7 = Virtual device (for optional use by third-party backup vendors)

9 = URL

Typically, only disk (2) and URL (9) are used.

[Column("type")]
[Nullable]
public byte? TypeColumn { get; set; }

Property Value

byte?

TypeDesc

Description of backup device type:

DISK

DISKETTE (obsolete)

TAPE

PIPE (obsolete)

VIRTUAL_DEVICE (for optional use by third party backup vendors)

URL

Typically, only DISK and URL are used.

[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string