How to setup an e-mail alert system for ApexSQL tools

Applies to
All ApexSQL console applications with Command line interfaces (CLI)

Summary
This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information.

ApexSQL Restore – Introduction

ApexSQL Restore is a SQL Server tool that attaches both native and natively compressed SQL database backups and transaction log backups as live databases, accessible via SQL Server Management Studio, Visual Studio or any third-party tool. It allows attaching a single or multiple full, differential and transaction log backups as well as mounting backup sets to a specific point in time, making it ideal for quickly reverting inadvertent or malicious changes.

When to use ApexSQL Restore

ApexSQL Restore can attach native or natively compressed backups and backup sets created in SQL Server 2000 and above to any edition of SQL Server 2005 and above, including full and differential database backups as well as transaction log backups

As such, ApexSQL Restore is very useful, among others, in the following scenarios: