When you need a SQL database fast, the cloud is the best way to go. Azure provides a SQL database as a Platform as a Service (PaaS) that eliminates the need to get an entire SQL Server up and running.
You've automated the SQL database backup process; now, let's restore in auto mode. Here's how to do it with PowerShell. In my last post, I demonstrated a script that can execute backups for a server.