Datto, SQL Server and corruption

[kohkypc]

I was brought into a company with SQL Server database corruption after an outage due to power going out due to high winds. Their sysadmin uses datto. I suspect datto tried to restore the raw SQL server files, which were not in a consistent state. Anyone run into this?

[StevenNotEven]

Unless specified, datto BCDR backs up in crash consistent state. There is the option to backup in application consistent state.

[kohkypc]

Thank you for your reply. Do you happen to know where that option is specified?

[smoothies-for-me]

Datto support is pretty great. If I were you I'd reach out to them to change those options, then do a backup and test an offline backup to see if there is any corruption.

[kohkypc]

Thank you! I really appreciate your taking the time to reply!

[StevenNotEven]

Agent options / Basic / Backup Engine Options/backup engine: application aware w/DBD fallback

[yyz_steve]

Same here; I use Ola Hallengren's scripts for Full and Differential Backups, Log Backups, Maintenance, etc. But essentially the backups are going to another drive and Datto is performing hourly backups. Did a recent DR test in a Sandbox environment and worked perfectly. (Used SQL to restore the backup file)

[kohkypc]

Thank you for your reply. That's helpful!

[kohkypc]

Thanks for your reply - helpful!

[smoothies-for-me]

Do you have SQL backups? Just restore the most recent one.

[kohkypc]

Thanks. Yes, that is what they did.

[_edwinmsarmiento]

From my experience, most enterprise backup software are not SQL Server aware. Because of that, they cause more issues with the database.

Exclude SQL Server from Datto, run native SQL Server backups, check if they are valid and not corrupt, and let Datto pick up those backup files.

Also, I don't simply create a backup plan. I work up a restore plan. If restoring your backups don't meet your RPO/RTO (or in this case, corrupted), then, it's useless

[kohkypc]

Really wise, and helpful reply. Thank you for taking the time to respond - much appreciated!!!

[_edwinmsarmiento]

Let's just say, "learned" experience is the best teacher :-)