BackupSet Class
Represents the backup set.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
| Name | Description | |
|---|---|---|
![]() | BackupFinishDate | Gets the date and time the backup operation finished. |
![]() | BackupMediaSet | Gets the backup media set. |
![]() | BackupSetGuid | Gets the unique backup set identification number that identifies the backup set. |
![]() | BackupSetType | Gets the backup set type whose value can be Database, Differential, Log, FileOrFilegroup. |
![]() | BackupSize | Gets the size of the backup set, in bytes. |
![]() | BackupStartDate | Gets the date and time when the backup operation started. |
![]() | BeginsLogChain | Gets a value that indicates whether the backup set is the first in a continuous chain of log backups. |
![]() | CheckpointLsn | Gets the log sequence number of the log record where redo must start. |
![]() | CompressedBackupSize | Gets the total byte count of the backup stored on disk. |
![]() | DatabaseBackupLsn | Gets the log sequence number of the most recent full database backup. |
![]() | DatabaseGuid | Gets the unique ID of the database where the backup was taken. |
![]() | DatabaseName | Gets the name of the database involved in the backup operation. |
![]() | Description | Gets the description of the backup set. |
![]() | DifferentialBaseGuid | Gets the unique identifier of the differential base for a single-based differential backup. |
![]() | DifferentialBaseLsn | Gets the base log sequence number for differential backups. |
![]() | ExpirationDate | Gets the date and time the backup set expires. |
![]() | FamilyGuid | Unique ID of the original database at creation. |
![]() | FirstLsn | Gets the log sequence number of the first or oldest log record in the backup set. |
![]() | FirstRecoveryForkID | Gets the ID of the starting recovery fork. |
![]() | ForkPointLsn | Gets the log sequence number of the fork point, if FirstRecoveryForkID is not equal to last RecoveryForkID. |
![]() | HasBulkLoggedData | Gets a value that indicates whether the backup contains bulk-logged data. |
![]() | HasIncompleteMetaData | Gets a value that indicates whether the backup is a tail log backup with incomplete metadata. |
![]() | IsCopyOnly | Gets a value that indicates whether the backup set is copy-only. |
![]() | 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 | Gets a value that indicates whether the database was offline when the backup was taken. |
![]() | IsReadOnly | Gets a value that indicates whether the database was read-only at the time of backup. |
![]() | IsSnapshot | Gets a value that indicates whether the backup was taken using the SNAPSHOT option. |
![]() | LastLsn | Gets the log sequence number of the next log record after the backup set. |
![]() | MachineName | Gets the name of the computer where the backup was taken. |
![]() | Name | Gets name of the backup set. |
![]() | Position | Gets the backup set position used in the restore operation to locate the position of appropriate backup set in the file. |
![]() | RecoveryForkID | Gets the ID of the ending recovery fork. |
![]() | ServerName | Gets the name of the server where the backup was taken. |
![]() | ServerVersion | Gets the Microsoft SQL Server version where the backup was taken. |
![]() | SoftwareVendorId | Gets the identification number of the software vendor writing the backup media header. |
![]() | UserName | Gets the name of the user who performed the backup operation. |
| Name | Description | |
|---|---|---|
![]() | Equals(Object^) | (Inherited from Object.) |
![]() | GetHashCode() | (Inherited from Object.) |
![]() | GetType() | (Inherited from Object.) |
![]() | ToString() | (Inherited from Object.) |
![]() | Verify() | Verifies the backup set. |
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

