BackupSet Class

Represents the backup set.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.BackupSet

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public NotInheritable Class BackupSet
'Usage
Dim instance As BackupSet

public sealed class BackupSet

public ref class BackupSet sealed

[<SealedAttribute>]
type BackupSet =  class end

public final class BackupSet

The BackupSet type exposes the following members.

Properties

	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.

Top

Methods

	Name	Description
	Equals	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	ToString	(Inherited from Object.)
	Verify	Verifies the backup set.

Top

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace