Test Your SQL Server Backups with PowerShell

The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White

That’s right. But it’s also a great example on how to work with MS SQL databases (connect, backup, restore, remote, SQLPS Module and more!): Test Your SQL Server Backups with PowerShell