SAP ABAP Table MSSRESHIST (MS SQL Server: Database restoration history overview)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSRESHIST	Table Relationship Diagram
Short Description	MS SQL Server: Database restoration history overview

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	RESTOREDAT	☐	MSSRESDATE	CHAR20	CHAR	20	0	MS SQL Server: Restoration date and time
2	SDBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
3	DBSIZE	☐	MSQDBSZ		DEC	14	4	MS SQL server DB size
4	BACKEDDATE	☐	MSSBKSTART	CHAR20	CHAR	20	0	MS SQL Server: Database starting time
5	RESTORETYP	☐	MSSBKTYPES		CHAR	30	0	MS SQL server - Backup Type description
6	RESTOREUSR	☐	MSQUSRNAME	CHAR128	CHAR	128	0	The user name used to log into the SQL Server database
7	RESTDEVICE	☐	MSSDEVNAME	TEXT30	CHAR	30	0	MS SQL Server: Logical device name
8	RESTDEVTYP	☐	MSSDEVDES		CHAR	30	0	MS SQLserver - Backup device type Description.
9	RESTVOLNAM	☐	MSQVOLNAME		CHAR	128	0	MS SQL server - backup device volume name.

History

Last changed by/on	SAP	20110908
SAP Release Created in