The MSS_DB02_BCKP event is used in SAP to analyze the database backup processes for a Microsoft SQL database.
Potential Use Cases
This event could be used in the following scenarios:
Alert on database backup failures
Dashboard on database backup history
Confirm last backup in case recovery is required.
The event will look like this in Splunk:
Log into the managed system and execute the dbacockpit transaction code. Expand the options for the Backup and Recovery section and double-click the Backup History option on the left side. The information displayed will match the data that is extracted and sent to Splunk.
Note: No backups had been run recently on the database in the screenshot below, but this is where this information will be populated.
Unit of Measure
MS SQL Server - Family num of media where the backup starts
MS SQL server backup id for the backup task
MS SQL Server - Backup set position
MS SQL server - Backup Type description
The date time stamp when the information was collected
MS Sql Server - Backup media set description
Description of the backup set
MS SQL server backup finish date
MS SQL server - backup expiration date
MS SQL job history
MS SQL server job id
MS SQL server - server name
Backup media set id
MS sql server desciption of the nedia name.
Name of the backup set
MS SQL Server server to be used for a SQL task execution
MS SQL Server - Backup software Name
MS SQL Server: Database starting time
MS SQL server - backup type ( full, differential, log)
The UTC OFFSSET in HHMMSS that the data was collected in
The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.
+ | -