BackupSet Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Backupset class
public sealed class BackupSettype BackupSet = classPublic 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, Decimal) |
Determines whether [backup sets in sequence]. |
| IsBackupSetsInSequence(BackupSet, BackupSet) |
Determines whether [backup sets in sequence]. |
| Verify() |
Verifies the backupset |