How can we improve Azure Backup?

← Azure Backup

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

12 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Brett Hinton shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Reed Hull commented  ·   ·  Flag as inappropriate

    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

Azure Backup

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice