Pain Point: Something bad happened and you need to restore a SQL Server database.
Pain Point you didn’t know you had: The backup files are all corrupt due a problem with the storage subsystem.
Solution: Do test restores with one line of code from DBATools.io
Set-DbatoolsInsecureConnection -SessionOnly Test-DbaLastBackup -SqlInstance Precision7770-1
You will need a modern version of PowerShell and the DBATools module. Also a destination for the test restores to land.
This video is not sponsored by Sean or Jen from MinionWare, they are just really nice people selling a SQL Server maintenance solution for large enterprises 🙂
Thanks for reading!