I have created backups using Azure DevOps server 2019 so I want to test the integrity of those backups. by testing I mean check that the backups are valid. I can't check them manually because of the huge amount of data so I thought about a hash function or something like that. if there is any tool or solution that may help or if there's any tool integrated in Azure DevOps server 2019 that does it automatically let me know and thank you!
Asked
Active
Viewed 57 times
1 Answers
1
Computing some checksums is not a restore test.
Restore databases for real. Prepare (test) database servers. Restore data, timing how long it takes. Connect test application servers, if available.
An outline of such a restore is in Azure DevOps Server documentation, although details likely need customization to your environment. In particular, whether the restore wizard can handle some details for you:
If you manually configured your backups, you cannot use the Restore wizard in Scheduled Backups to restore those databases. You must manually restore them using the software you used to back them up.
Unfortunately, restore of a general purpose, multiple tier, database application like this can be a bit of work. Encourage leadership to do restores regularly, at least on major infrastructure changes like a new backup system.
John Mahowald
- 30,009
- 1
- 17
- 32
-
so the short-term solution is to restore data and check, and the long-term one is a new backup system. am I right? if so do you have any suggestions ? Thank you – Retro_0 Sep 08 '21 at 07:09
-
Regularly restore data to improve confidence in your recovery procedures. There is no one button to push that automates documenting the process, the restore itself, and the report on whether you meet your recovery time objectives. – John Mahowald Sep 09 '21 at 13:03