invantive documentation
Invantive Support ForumsLog In / Sign Up

backupset: SQL Server

insert update delete

  • Catalog: msdb
  • Schema: dbo
  • Primary Keys: backup_set_id

Can retrieve data and change data using insert, update and delete.

Table Columns

The columns of the table backupset are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type 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