Export (0) Print
Expand All

BackupSet Properties

The BackupSet type exposes the following members.

  Name Description
Public property BackupFinishDate Gets the date and time the backup operation finished.
Public property BackupMediaSet Gets the backup media set.
Public property BackupSetGuid Gets the unique backup set identification number that identifies the backup set.
Public property BackupSetType Gets the backup set type whose value can be Database, Differential, Log, FileOrFilegroup.
Public property BackupSize Gets the size of the backup set, in bytes.
Public property BackupStartDate Gets the date and time when the backup operation started.
Public property BeginsLogChain Gets a value that indicates whether the backup set is the first in a continuous chain of log backups.
Public property CheckpointLsn Gets the log sequence number of the log record where redo must start.
Public property CompressedBackupSize Gets the total byte count of the backup stored on disk.
Public property DatabaseBackupLsn Gets the log sequence number of the most recent full database backup.
Public property DatabaseGuid Gets the unique ID of the database where the backup was taken.
Public property DatabaseName Gets the name of the database involved in the backup operation.
Public property Description Gets the description of the backup set.
Public property DifferentialBaseGuid Gets the unique identifier of the differential base for a single-based differential backup.
Public property DifferentialBaseLsn Gets the base log sequence number for differential backups.
Public property ExpirationDate Gets the date and time the backup set expires.
Public property FamilyGuid Unique ID of the original database at creation.
Public property FirstLsn Gets the log sequence number of the first or oldest log record in the backup set.
Public property FirstRecoveryForkID Gets the ID of the starting recovery fork.
Public property ForkPointLsn Gets the log sequence number of the fork point, if FirstRecoveryForkID is not equal to last RecoveryForkID.
Public property HasBulkLoggedData Gets a value that indicates whether the backup contains bulk-logged data.
Public property HasIncompleteMetaData Gets a value that indicates whether the backup is a tail log backup with incomplete metadata.
Public property IsCopyOnly Gets a value that indicates whether the backup set is copy-only.
Public property 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.
Public property IsForceOffline Gets a value that indicates whether the database was offline when the backup was taken.
Public property IsReadOnly Gets a value that indicates whether the database was read-only at the time of backup.
Public property IsSnapshot Gets a value that indicates whether the backup was taken using the SNAPSHOT option.
Public property LastLsn Gets the log sequence number of the next log record after the backup set.
Public property MachineName Gets the name of the computer where the backup was taken.
Public property Name Gets name of the backup set.
Public property Position Gets the backup set position used in the restore operation to locate the position of appropriate backup set in the file.
Public property RecoveryForkID Gets the ID of the ending recovery fork.
Public property ServerName Gets the name of the server where the backup was taken.
Public property ServerVersion Gets the Microsoft SQL Server version where the backup was taken.
Public property SoftwareVendorId Gets the identification number of the software vendor writing the backup media header.
Public property UserName Gets the name of the user who performed the backup operation.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft