New Dba: Date Desc [upd]

# Get the most recent backup for each database Get-DbaLastBackup -SqlInstance "YourServerName" | Select-Object Database, LastBackupDate | Sort-Object LastBackupDate -Descending Use code with caution. Copied to clipboard Why Use DESC with Dates?

(e.g., a script that emails you this list daily)? New-DbaAgentSchedule | dbatools new dba date desc

: Refers to system-level tables (e.g., DBA_OBJECTS or DBA_TABLES ) that only administrators can access. # Get the most recent backup for each