Automated Database Restoration And CHECKDB

Anthony Nocentino shows how to use dbatools to automate testing restoration of database backups and running DBCC CHECKDB against these restored backups:

Requirements

1. Automation – Complete autopilot, no human interaction.
2. Report job status – Accurate reporting in the event the job failed, the CHECKDB failed or the restore failed.

Solution

1. Use dbaltools cmdlets for restore and CHECKDB operations
2. Use SQL Agent Job automation, logging and alerting

So let’s walk through this implementation together.

You won’t get a turnkey solution from this blog post, but you will get a good process to follow.