DPAS SCR: 01817

• SCR Number
  01817
• Title
  Database Backup Monitoring
• DPAS Module
  Enterprise
• Reporting Organization
  Leidos
• State
  Done
• History
  Submitted: 09/22/2022
• Description
  Description:

  Control activity 5.4 states: “DLA Information Operations personnel monitor the successful completion of database backup and document the results in a monthly MFR.”
  • From October 2021 through May 2022 DPAS did not actively monitor the successful completion of database backups. DPAS researched database backup failures if they were notified of any through an automated notification process. DPAS was also unable to provide evidence demonstrating this control since database backup logs or database backup notifications were not retained.

  
  

  Recommended:

  Add a new table, Stored Procedure, and SQL Agent job to support the monitoring.

   

  Mission Critical:

  Mandated - This SCR is required to resolve a NFR in the FY22 SSAE audit.  

   

  Benefits:

  Passing the next SSAE audit.  

   

  Users:

  This process will be used mainly by the DBAs.  

   

   

  Completed – Release 2022.2.2 – 23 September 2022