Azure Devops Server 2019 Backup testing

in flag

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!

cn flag

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.

Retro_0 avatar
in flag
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
John Mahowald avatar
cn flag
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.

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.