BackupSet Class

Definition

Namespace:

Microsoft.SqlServer.Management.Smo

Assembly:

Microsoft.SqlServer.Smo.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Backupset class

public sealed class BackupSet

type BackupSet = class

Public NotInheritable Class BackupSet

Inheritance

Object

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