Time and Attendance Database Refresh Audit

Owned by Knowledge Assistant
Apr 09, 2024
1 min read
Description of Issue

Client is wanting to know if there is a history in SQL that will determine the last time data was refreshed in their non-prod instance

Context

  • Time and Attendance

  • ExecuTime

  • SQL

  • SSMS

Cause

Informational

Resolution

  1. Open SSMS and connect to target SQL Instance

  2. Right-click the target database

  3. Select Reports > Standard Reports > Backup and Restore events > Successful Restore Options

    1. This will show the history of restore operations against target databases. 

Additional Information