Classe BackupSet

Represents the backup set.

Hierarquia de herança

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

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

Sintaxe

'Declaração
Public NotInheritable Class BackupSet
'Uso
Dim instance As BackupSet
public sealed class BackupSet
public ref class BackupSet sealed
[<SealedAttribute>]
type BackupSet =  class end
public final class BackupSet

O tipo BackupSet expõe os membros a seguir.

Propriedades

  Nome Descrição
Propriedade pública BackupFinishDate Gets the date and time the backup operation finished.
Propriedade pública BackupMediaSet Gets the backup media set.
Propriedade pública BackupSetGuid Gets the unique backup set identification number that identifies the backup set.
Propriedade pública BackupSetType Gets the backup set type whose value can be Database, Differential, Log, FileOrFilegroup.
Propriedade pública BackupSize Gets the size of the backup set, in bytes.
Propriedade pública BackupStartDate Gets the date and time when the backup operation started.
Propriedade pública BeginsLogChain Gets a value that indicates whether the backup set is the first in a continuous chain of log backups.
Propriedade pública CheckpointLsn Gets the log sequence number of the log record where redo must start.
Propriedade pública CompressedBackupSize Gets the total byte count of the backup stored on disk.
Propriedade pública DatabaseBackupLsn Gets the log sequence number of the most recent full database backup.
Propriedade pública DatabaseGuid Gets the unique ID of the database where the backup was taken.
Propriedade pública DatabaseName Gets the name of the database involved in the backup operation.
Propriedade pública Description Gets the description of the backup set.
Propriedade pública DifferentialBaseGuid Gets the unique identifier of the differential base for a single-based differential backup.
Propriedade pública DifferentialBaseLsn Gets the base log sequence number for differential backups.
Propriedade pública ExpirationDate Gets the date and time the backup set expires.
Propriedade pública FamilyGuid Unique ID of the original database at creation.
Propriedade pública FirstLsn Gets the log sequence number of the first or oldest log record in the backup set.
Propriedade pública FirstRecoveryForkID Gets the ID of the starting recovery fork.
Propriedade pública ForkPointLsn Gets the log sequence number of the fork point, if FirstRecoveryForkID is not equal to last RecoveryForkID.
Propriedade pública HasBulkLoggedData Gets a value that indicates whether the backup contains bulk-logged data.
Propriedade pública HasIncompleteMetaData Gets a value that indicates whether the backup is a tail log backup with incomplete metadata.
Propriedade pública IsCopyOnly Gets a value that indicates whether the backup set is copy-only.
Propriedade pública 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.
Propriedade pública IsForceOffline Gets a value that indicates whether the database was offline when the backup was taken.
Propriedade pública IsReadOnly Gets a value that indicates whether the database was read-only at the time of backup.
Propriedade pública IsSnapshot Gets a value that indicates whether the backup was taken using the SNAPSHOT option.
Propriedade pública LastLsn Gets the log sequence number of the next log record after the backup set.
Propriedade pública MachineName Gets the name of the computer where the backup was taken.
Propriedade pública Name Gets name of the backup set.
Propriedade pública Position Gets the backup set position used in the restore operation to locate the position of appropriate backup set in the file.
Propriedade pública RecoveryForkID Gets the ID of the ending recovery fork.
Propriedade pública ServerName Gets the name of the server where the backup was taken.
Propriedade pública ServerVersion Gets the Microsoft SQL Server version where the backup was taken.
Propriedade pública SoftwareVendorId Gets the identification number of the software vendor writing the backup media header.
Propriedade pública UserName Gets the name of the user who performed the backup operation.

Início

Métodos

  Nome Descrição
Método público Equals (Herdado de Object.)
Método público GetHashCode (Herdado de Object.)
Método público GetType (Herdado de Object.)
Método público ToString (Herdado de Object.)
Método público Verify Verifies the backup set.

Início

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo