Testing Backups With dbatools

Constantine Kokkinos shows off a dbatools cmdlet to test the last full backup:

This:

• Defines a list of two servers (PowerShell lists are as easy as “”,””)

• Pipes them to the Test-DbaLastBackup command.

• Which then:

  • Gathers information about the last full backups for all of your databases on that instance.

  • Restores the backups to the Destination with a new name. If no Destination is specified, the originating server will be used.

  • The database is restored as “dbatools-testrestore-$databaseName” by default, which you can change with the -Prefix parameter.

  • The internal file names are also renamed to prevent conflicts with original database.

  • A DBCC CHECKTABLE is then performed.

  • And the test database is finally dropped.

Pretty snazzy.