TechNet
Export (0) Print
Expand All

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 ref class BackupSet sealed 

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:
© 2016 Microsoft