Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

BackupSet Class

SQL Server 2012

Represents the backup set.

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public sealed class BackupSet

The BackupSet type exposes the following members.

  NameDescription
Public propertyBackupFinishDateGets the date and time the backup operation finished.
Public propertyBackupMediaSetGets the backup media set.
Public propertyBackupSetGuidGets the unique backup set identification number that identifies the backup set.
Public propertyBackupSetTypeGets the backup set type whose value can be Database, Differential, Log, FileOrFilegroup.
Public propertyBackupSizeGets the size of the backup set, in bytes.
Public propertyBackupStartDateGets the date and time when the backup operation started.
Public propertyBeginsLogChainGets a value that indicates whether the backup set is the first in a continuous chain of log backups.
Public propertyCheckpointLsnGets the log sequence number of the log record where redo must start.
Public propertyCompressedBackupSizeGets the total byte count of the backup stored on disk.
Public propertyDatabaseBackupLsnGets the log sequence number of the most recent full database backup.
Public propertyDatabaseGuidGets the unique ID of the database where the backup was taken.
Public propertyDatabaseNameGets the name of the database involved in the backup operation.
Public propertyDescriptionGets the description of the backup set.
Public propertyDifferentialBaseGuidGets the unique identifier of the differential base for a single-based differential backup.
Public propertyDifferentialBaseLsnGets the base log sequence number for differential backups.
Public propertyExpirationDateGets the date and time the backup set expires.
Public propertyFamilyGuidUnique ID of the original database at creation.
Public propertyFirstLsnGets the log sequence number of the first or oldest log record in the backup set.
Public propertyFirstRecoveryForkIDGets the ID of the starting recovery fork.
Public propertyForkPointLsnGets the log sequence number of the fork point, if FirstRecoveryForkID is not equal to last RecoveryForkID.
Public propertyHasBulkLoggedDataGets a value that indicates whether the backup contains bulk-logged data.
Public propertyHasIncompleteMetaDataGets a value that indicates whether the backup is a tail log backup with incomplete metadata.
Public propertyIsCopyOnlyGets a value that indicates whether the backup set is copy-only.
Public propertyIsDamagedGets 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.
Public propertyIsForceOfflineGets a value that indicates whether the database was offline when the backup was taken.
Public propertyIsReadOnlyGets a value that indicates whether the database was read-only at the time of backup.
Public propertyIsSnapshotGets a value that indicates whether the backup was taken using the SNAPSHOT option.
Public propertyLastLsnGets the log sequence number of the next log record after the backup set.
Public propertyMachineNameGets the name of the computer where the backup was taken.
Public propertyNameGets name of the backup set.
Public propertyPositionGets the backup set position used in the restore operation to locate the position of appropriate backup set in the file.
Public propertyRecoveryForkIDGets the ID of the ending recovery fork.
Public propertyServerNameGets the name of the server where the backup was taken.
Public propertyServerVersionGets the Microsoft SQL Server version where the backup was taken.
Public propertySoftwareVendorIdGets the identification number of the software vendor writing the backup media header.
Public propertyUserNameGets the name of the user who performed the backup operation.
Top
  NameDescription
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodToString (Inherited from Object.)
Public methodVerifyVerifies the backup set.
Top
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.