How to Test Restore Your SQL Server Databases!

If you are not doing test restores from your SQL Server backups, how do you know they are any good in an emergency?
Contact us: www.DallasDBAs.com/contact
Our Services: www.DallasDBAs.com/services

[@mtsurov]

Good info. As my DBA friends say, we don't get paid to backup databases, we get paid to restore them.
Appreciate your content.

[@Kevin3NF]

Thanks! I appreciate that :)

[@tonycovarrubias5931]

This one probably doesn't work with TDE databases as you described since you need DEKs on both ends

[@Kevin3NF]

Thanks Tony...that didn't even occur to me since I very rarely see TDE :)

[@Rjhaack]

Our problem is that we don't do the backups our server team does and they use Rubrik. Is there a way I can use this command to connect to Rubrik and get the restore that way?

[@Kevin3NF]

Sorry sir, I'm aware that Rubrik exists but know nothing about how it works