SAP ABAP Table MSQBACKSET (MS SQL server backup list)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
Basic Data
| Table Category | INTTAB | Structure |
| Structure | MSQBACKSET |
Table Relationship Diagram 
|
| Short Description | MS SQL server backup list |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  DBNAME |
MSSDB | MSSSYSNAME | CHAR | 128 | 0 | Database name | ||
| 2 | BKUPTYPE |
MSSBKTYPES | CHAR | 30 | 0 | MS SQL server - Backup Type description | |||
| 3 | BACKSTART |
MSQBKFINDT | CHAR | 20 | 0 | MS SQL server backup finish date | |||
| 4 | BACKDEVNAM |
MSQDEVNAME | MSSSYSNAME | CHAR | 128 | 0 | MS SQL server backup device name | ||
| 5 | VOLUMENAME |
MSQBKMEDNA | CHAR | 128 | 0 | MS SQL Server - Desciption of the media name | |||
| 6 | BACKUPID |
MSQBAKUPID | INT4 | INT4 | 10 | 0 | MS SQL Server backup ID for the backup task | ||
| 7 | BKUPNAME |
MSSBKNAME | MSSSYSNAME | CHAR | 128 | 0 | Name of the backup set | ||
| 8 | BKUPDESC |
MSSBKDESC | CHAR | 255 | 0 | Description of the backup set | |||
| 9 | BACKDBSIZE |
MSQDBSZ | DEC | 14 | 4 | MS SQL server DB size | |||
| 10 | BKUPDURA |
MSSBKDURA | CHAR | 8 | 0 | Backup job run duration |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 610 |
