BackupSet Class

Definition

Backupset class

public sealed class BackupSet
type BackupSet = class
Public NotInheritable Class BackupSet
Inheritance
BackupSet

Properties

BackupFinishDate

Date and time the backup operation finished.

BackupMediaSet

Gets the backup media set.

BackupSetGuid

Unique backup set identification number that identifies the backup set.

BackupSetType

Gets the Backup set type. Can be: Database, Differential, Log, FileOrFilegroup

BackupSize

Size of the backup set, in bytes.

BackupStartDate

Gets Datetime when the backup operation started.

BeginsLogChain

Is this the first in a continuous chain of log backups. A log chain begins with the first log backup taken after the database is created or when it is switched from the simple to the full or bulk-logged recovery model.

CheckpointLsn

Log sequence number of the log record where redo must start.

CompressedBackupSize

Total Byte count of the backup stored on disk.

DatabaseBackupLsn

Log sequence number of the most recent full database backup.

DatabaseGuid

Unique ID of the database where the backup was taken. When the database is restored, a new value is assigned.

DatabaseName

Name of the database involved in the backup operation.

Description

Gets the description.

DifferentialBaseGuid

For a single-based differential backup, the value is the unique identifier of the differential base.

DifferentialBaseLsn

Base LSN for differential backups. Changes with LSNs greater than or equal to differential_base_lsn are included in the differential backup.

ExpirationDate

Date and time the backup set expires.

FamilyGuid

Unique ID of the original database at creation. This value remains the same when the database is restored, even to a different name.

FirstLsn

Log sequence number of the first or oldest log record in the backup set.

FirstRecoveryForkID

ID of the starting recovery fork.

ForkPointLsn

If first_recovery_fork_guid is not equal to last_recovery_fork_guid, this is the log sequence number of the fork point.

HasBulkLoggedData

Does the Backup contain bulk-logged data.

HasIncompleteMetaData

Is the backup a tail log backup with incomplete metadata.

IsCopyOnly

Is the backupset Copy-only.

IsDamaged

Was damage to the database detected when this backup was created, and the backup operation was requested to continue despite errors.

IsForceOffline

Was the Database offline when the backup was taken.

IsReadOnly

Was database read-only at the time of backup.

IsSnapshot

Was Backup taken using the SNAPSHOT option.

LastLsn

Log sequence number of the next log record after the backup set.

MachineName

Name of the computer where the Backup was taken.

Name

Gets name of the backup set.

Parent

Gets Parent of the object

Position

Backup set position used in the restore operation to locate the position of appropriate backup set in the file.

RecoveryForkID

ID of the ending recovery fork.

ServerName

Name of the server where the Backup was taken.

ServerVersion

Microsoft SQL Server version where the backup was taken.

SoftwareVendorId

Identification number of the software vendor writing the backup media header.

UserName

Name of the user who performed the backup operation.

Methods

CheckBackupFilesExistence()

Checks the backup files existence.

GetFileList()

Returns a the set of files associated with the BackupSet

IsBackupSetsInSequence(BackupSet, BackupSet)

Determines whether [backup sets in sequence].

IsBackupSetsInSequence(BackupSet, BackupSet, Decimal)

Determines whether [backup sets in sequence].

Verify()

Verifies the backupset

Applies to