SQL Database Restore (and create) from file

Connects to a specified SQL instance, and restores a .BAK backup over an existing database, or creates a new one and restores over that instead.

Remember - the SQL service account needs access to the location the .BAK is restored from.