'Is there a recommended way to test SQL Server backups that are taken from Azure vms to the Recovery Service vaults?
We have a number of Azure vms running SQL Server and all the backups are being taken into the Recovery Service Vaults. If we want to test a backup then the backup for a database needs to be restored as a file and then restored somewhere else to make sure that it restores and integrity is all ok.
I can't find any recommendations on the best practice for testing backups that are stored in the recovery service vaults. Exporting a handful of databases is ok but as the number of systems growth then it isn't feasible to manually export and test each database.
I've used dbatools.io Test-DbaLastBackup for testing on site backups but as we are moving into azure then testing backups is becoming harder.
Are there any recommendations or best practices that are available?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|