If you use Ola Hallengren’s maintenance scripts, you need a fast, easy way to restore, test, and CHECKDB your backups. That’s sp_DatabaseRestore: The sp_BlitzBackups stored proc isn’t glamorous, but it calculates your current worst-case for Recovery Point Objective and Recovery Time Objective, which are also performance metrics too:
07 Reduce Your Risks with sp_DatabaseRestore and sp_BlitzBackup
If you use Ola Hallengren’s maintenance scripts, you need a fast, easy way to restore, test, and CHECKDB your backups. That’s sp_DatabaseRestore: The sp_BlitzBackups stored proc isn’t glamorous, but it calculates your current worst-case for Recovery Point Objective and Recovery Time Objective, which are also performance metrics too:
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
- 00 Prerequisites Before the Class
- 01 Doing a Server-Wide Health Check with sp_Blitz
- 02 Doing a Server-Wide Performance Check with sp_BlitzFirst
- 03 Using sp_BlitzCache to Find the Queries Causing Your Top Waits
- 04 Using sp_BlitzIndex to Diagnose the Most Urgent Index Issues
- 05 Analyzing Deadlocks with sp_BlitzLock
- 06 Check Which Queries Are Running with sp_BlitzWho and sp_WhoIsActive
- 08 Automate the Data-Gathering Process with the Consultant Toolkit
- 09 Recap and Writing Up Your Findings