BackupSet Class

 

Represents the backup set.

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

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

public sealed class BackupSet

NameDescription
System_CAPS_pubpropertyBackupFinishDate

Gets the date and time the backup operation finished.

System_CAPS_pubpropertyBackupMediaSet

Gets the backup media set.

System_CAPS_pubpropertyBackupSetGuid

Gets the unique backup set identification number that identifies the backup set.

System_CAPS_pubpropertyBackupSetType

Gets the backup set type whose value can be Database, Differential, Log, FileOrFilegroup.

System_CAPS_pubpropertyBackupSize

Gets the size of the backup set, in bytes.

System_CAPS_pubpropertyBackupStartDate

Gets the date and time when the backup operation started.

System_CAPS_pubpropertyBeginsLogChain

Gets a value that indicates whether the backup set is the first in a continuous chain of log backups.

System_CAPS_pubpropertyCheckpointLsn

Gets the log sequence number of the log record where redo must start.

System_CAPS_pubpropertyCompressedBackupSize

Gets the total byte count of the backup stored on disk.

System_CAPS_pubpropertyDatabaseBackupLsn

Gets the log sequence number of the most recent full database backup.

System_CAPS_pubpropertyDatabaseGuid

Gets the unique ID of the database where the backup was taken.

System_CAPS_pubpropertyDatabaseName

Gets the name of the database involved in the backup operation.

System_CAPS_pubpropertyDescription

Gets the description of the backup set.

System_CAPS_pubpropertyDifferentialBaseGuid

Gets the unique identifier of the differential base for a single-based differential backup.

System_CAPS_pubpropertyDifferentialBaseLsn

Gets the base log sequence number for differential backups.

System_CAPS_pubpropertyExpirationDate

Gets the date and time the backup set expires.

System_CAPS_pubpropertyFamilyGuid

Unique ID of the original database at creation.

System_CAPS_pubpropertyFirstLsn

Gets the log sequence number of the first or oldest log record in the backup set.

System_CAPS_pubpropertyFirstRecoveryForkID

Gets the ID of the starting recovery fork.

System_CAPS_pubpropertyForkPointLsn

Gets the log sequence number of the fork point, if FirstRecoveryForkID is not equal to last RecoveryForkID.

System_CAPS_pubpropertyHasBulkLoggedData

Gets a value that indicates whether the backup contains bulk-logged data.

System_CAPS_pubpropertyHasIncompleteMetaData

Gets a value that indicates whether the backup is a tail log backup with incomplete metadata.

System_CAPS_pubpropertyIsCopyOnly

Gets a value that indicates whether the backup set is copy-only.

System_CAPS_pubpropertyIsDamaged

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.

System_CAPS_pubpropertyIsForceOffline

Gets a value that indicates whether the database was offline when the backup was taken.

System_CAPS_pubpropertyIsReadOnly

Gets a value that indicates whether the database was read-only at the time of backup.

System_CAPS_pubpropertyIsSnapshot

Gets a value that indicates whether the backup was taken using the SNAPSHOT option.

System_CAPS_pubpropertyLastLsn

Gets the log sequence number of the next log record after the backup set.

System_CAPS_pubpropertyMachineName

Gets the name of the computer where the backup was taken.

System_CAPS_pubpropertyName

Gets name of the backup set.

System_CAPS_pubpropertyPosition

Gets the backup set position used in the restore operation to locate the position of appropriate backup set in the file.

System_CAPS_pubpropertyRecoveryForkID

Gets the ID of the ending recovery fork.

System_CAPS_pubpropertyServerName

Gets the name of the server where the backup was taken.

System_CAPS_pubpropertyServerVersion

Gets the Microsoft SQL Server version where the backup was taken.

System_CAPS_pubpropertySoftwareVendorId

Gets the identification number of the software vendor writing the backup media header.

System_CAPS_pubpropertyUserName

Gets the name of the user who performed the backup operation.

NameDescription
System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodVerify()

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.

Return to top
Show: