Automated Microsoft MS SQL-Server / TSQL: backup and export or restore and import .bak Database backup files for attachment

When frequently transferring and restoring backups during development it is advantageous to restore these in a more efficient manner.
Author: Rafi, Free for personal use. Psd file download

One possible solution to this task using Microsoft SQL Server 2005 or higher can be found below: