invantive documentation
Invantive Support ForumsLog In / Sign Up

backupfile: 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 backupfile 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
backed_up_page_count decimal
backup_set_id int32
backup_size decimal
create_lsn decimal
differential_base_guid guid
differential_base_lsn decimal
drop_lsn decimal
file_guid guid
file_number decimal
file_size decimal
file_type char
filegroup_guid guid
filegroup_name varchar2
first_family_number int16
first_media_number int16
is_present char
is_readonly char
logical_name varchar2
page_size int32
physical_drive varchar2
physical_name varchar2
read_only_lsn decimal
read_write_lsn decimal
source_file_block_size decimal
state int16
state_desc varchar2