SQL Server DBA

dbatools for SQL Server Administration

Question

Get-DbaLastBackup versus Test-DbaLastBackup: which reports coverage versus validates recoverability?

Answer

Get-DbaLastBackup reports the latest backup metadata and age. Test-DbaLastBackup restores eligible backups to validate them. Use the first for compliance reporting; use the second for recovery verification.

This is 19 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples