# backupset - Catalog: `msdb` - Schema: `dbo` - Primary Keys: `backup_set_id` The data in this table is partitioned per value of the column. 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `backup_finish_date` | `datetime` | | ☐ | | | `backup_set_id` | `int32` | | ☐ | | | `backup_set_uuid` | `guid` | | ☐ | | | `backup_size` | `decimal` | | ☐ | | | `backup_start_date` | `datetime` | | ☐ | | | `begins_log_chain` | `boolean` | | ☐ | | | `catalog_family_number` | `int16` | | ☐ | | | `catalog_media_number` | `int16` | | ☐ | | | `checkpoint_lsn` | `decimal` | | ☐ | | | `code_page` | `int16` | | ☐ | | | `collation_name` | `string` | | ☐ | | | `compatibility_level` | `int16` | | ☐ | | | `compressed_backup_size` | `decimal` | | ☐ | | | `database_backup_lsn` | `decimal` | | ☐ | | | `database_creation_date` | `datetime` | | ☐ | | | `database_guid` | `guid` | | ☐ | | | `database_name` | `string` | | ☐ | | | `database_version` | `int32` | | ☐ | | | `description` | `string` | | ☐ | | | `differential_base_guid` | `guid` | | ☐ | | | `differential_base_lsn` | `decimal` | | ☐ | | | `encryptor_thumbprint` | `byte[]` | | ☐ | | | `encryptor_type` | `string` | | ☐ | | | `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` | `boolean` | | ☐ | | | `has_bulk_logged_data` | `boolean` | | ☐ | | | `has_incomplete_metadata` | `boolean` | | ☐ | | | `is_copy_only` | `boolean` | | ☐ | | | `is_damaged` | `boolean` | | ☐ | | | `is_force_offline` | `boolean` | | ☐ | | | `is_password_protected` | `boolean` | | ☐ | | | `is_readonly` | `boolean` | | ☐ | | | `is_single_user` | `boolean` | | ☐ | | | `is_snapshot` | `boolean` | | ☐ | | | `key_algorithm` | `string` | | ☐ | | | `last_family_number` | `int16` | | ☐ | | | `last_lsn` | `decimal` | | ☐ | | | `last_media_number` | `int16` | | ☐ | | | `last_recovery_fork_guid` | `guid` | | ☐ | | | `machine_name` | `string` | | ☐ | | | `media_set_id` | `int32` | | ☐ | | | `mtf_minor_version` | `int16` | | ☐ | | | `name` | `string` | | ☐ | | | `position` | `int32` | | ☐ | | | `recovery_model` | `string` | | ☐ | | | `server_name` | `string` | | ☐ | | | `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` | `string` | | ☐ | |