BackupSet BackupSet BackupSet Class

Definition

Represents the backup set.

public ref class BackupSet sealed
public sealed class BackupSet
Public NotInheritable Class BackupSet
Inheritance
BackupSetBackupSetBackupSet

Properties

BackupFinishDate BackupFinishDate BackupFinishDate

Gets the date and time the backup operation finished.

BackupMediaSet BackupMediaSet BackupMediaSet

Gets the backup media set.

BackupSetGuid BackupSetGuid BackupSetGuid

Gets the unique backup set identification number that identifies the backup set.

BackupSetType BackupSetType BackupSetType

Gets the backup set type whose value can be Database, Differential, Log, FileOrFilegroup.

BackupSize BackupSize BackupSize

Gets the size of the backup set, in bytes.

BackupStartDate BackupStartDate BackupStartDate

Gets the date and time when the backup operation started.

BeginsLogChain BeginsLogChain BeginsLogChain

Gets a value that indicates whether the backup set is the first in a continuous chain of log backups.

CheckpointLsn CheckpointLsn CheckpointLsn

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

CompressedBackupSize CompressedBackupSize CompressedBackupSize

Gets the total byte count of the backup stored on disk.

DatabaseBackupLsn DatabaseBackupLsn DatabaseBackupLsn

Gets the log sequence number of the most recent full database backup.

DatabaseGuid DatabaseGuid DatabaseGuid

Gets the unique ID of the database where the backup was taken.

DatabaseName DatabaseName DatabaseName

Gets the name of the database involved in the backup operation.

Description Description Description

Gets the description of the backup set.

DifferentialBaseGuid DifferentialBaseGuid DifferentialBaseGuid

Gets the unique identifier of the differential base for a single-based differential backup.

DifferentialBaseLsn DifferentialBaseLsn DifferentialBaseLsn

Gets the base log sequence number for differential backups.

ExpirationDate ExpirationDate ExpirationDate

Gets the date and time the backup set expires.

FamilyGuid FamilyGuid FamilyGuid

Unique ID of the original database at creation.

FirstLsn FirstLsn FirstLsn

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

FirstRecoveryForkID FirstRecoveryForkID FirstRecoveryForkID

Gets the ID of the starting recovery fork.

ForkPointLsn ForkPointLsn ForkPointLsn

Gets the log sequence number of the fork point, if FirstRecoveryForkID is not equal to last RecoveryForkID.

HasBulkLoggedData HasBulkLoggedData HasBulkLoggedData

Gets a value that indicates whether the backup contains bulk-logged data.

HasIncompleteMetaData HasIncompleteMetaData HasIncompleteMetaData

Gets a value that indicates whether the backup is a tail log backup with incomplete metadata.

IsCopyOnly IsCopyOnly IsCopyOnly

Gets a value that indicates whether the backup set is copy-only.

IsDamaged IsDamaged IsDamaged

Gets a value that indicates whether damage to the database was detected when this backup was created, and the backup operation was requested to continue despite errors.

IsForceOffline IsForceOffline IsForceOffline

Gets a value that indicates whether the database was offline when the backup was taken.

IsReadOnly IsReadOnly IsReadOnly

Gets a value that indicates whether the database was read-only at the time of backup.

IsSnapshot IsSnapshot IsSnapshot

Gets a value that indicates whether the backup was taken using the SNAPSHOT option.

LastLsn LastLsn LastLsn

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

MachineName MachineName MachineName

Gets the name of the computer where the backup was taken.

Name Name Name

Gets name of the backup set.

Position Position Position

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

RecoveryForkID RecoveryForkID RecoveryForkID

Gets the ID of the ending recovery fork.

ServerName ServerName ServerName

Gets the name of the server where the backup was taken.

ServerVersion ServerVersion ServerVersion

Gets the Microsoft SQL Server version where the backup was taken.

SoftwareVendorId SoftwareVendorId SoftwareVendorId

Gets the identification number of the software vendor writing the backup media header.

UserName UserName UserName

Gets the name of the user who performed the backup operation.

Methods

Verify() Verify() Verify()

Verifies the backup set.

Applies to