invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

backupset: SQL Server

insert update delete

  • Catálogo: msdb
  • Esquema: dbo
  • Llaves Primarias: backup_set_id

Permite recuperar y modificar datos utilizando insert, update y delete.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla backupset. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
backup_finish_date datetime
backup_set_id int32
backup_set_uuid guid
backup_size decimal
backup_start_date datetime
begins_log_chain char
catalog_family_number int16
catalog_media_number int16
checkpoint_lsn decimal
code_page int16
collation_name varchar2
compatibility_level int16
compressed_backup_size decimal
database_backup_lsn decimal
database_creation_date datetime
database_guid guid
database_name varchar2
database_version int32
description varchar2
differential_base_guid guid
differential_base_lsn decimal
encryptor_thumbprint blob
encryptor_type varchar2
expiration_date datetime
family_guid guid
first_family_number int16
first_lsn decimal
first_media_number int16
first_recovery_fork_guid guid
flags int32
fork_point_lsn decimal
has_backup_checksums char
has_bulk_logged_data char
has_incomplete_metadata char
is_copy_only char
is_damaged char
is_force_offline char
is_password_protected char
is_readonly char
is_single_user char
is_snapshot char
key_algorithm varchar2
last_family_number int16
last_lsn decimal
last_media_number int16
last_recovery_fork_guid guid
machine_name varchar2
media_set_id int32
mtf_minor_version int16
name varchar2
position int32
recovery_model varchar2
server_name varchar2
software_build_version int16
software_major_version int16
software_minor_version int16
software_vendor_id int32
sort_order int16
time_zone int16
type char
unicode_compare_style int32
unicode_locale int32
user_name varchar2