.png)
BackupSet Properties
SQL Server 2012
The BackupSet type exposes the following members.
| 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. |
