Provide automatic testing/validation of database backups for Azure Backup for SQL Server in Azure Virtual Machines
Given this enterprise backup solution, it would be ideal to have a built-in solution for some automatic verification of database backups (like rotating dbcc checks of restored of databases and then removing the restored database and moving on to the next one).
Extra credit for being able to specify how many concurrent tests that could be done. Extra, extra credit for having a system that might predict how many need to be done concurrently to test the backed up databases on some schedule
Brett Hinton
shared this idea
2 comments
-
Anonymous
commented
This is valuable beyond measure.
-
Reed Hull
commented
Our initial thought was to test database restores by:
1. Spinning-up a new SQL Server VM with storage equivalent to the instance being restored from
2. Restore all non-system (user) databases
3. Run DBCC CHECKDB on all restored databases
4. Tear-down the VM
5. Repeat