Aaron's Ramblings

If you need to restore a SQL Database from a .BAK file that is stored on a network drive. Here is the script you can use to do it.

restore database DB_NAME from disk='\\Server_Name\Backup_Folder\Backup_File'
with move 'DB_NAME_Data' to 'C:\Path_To_MDF_File\DB_NAME.mdf',
move 'DB_NAME_log' to 'C:\Path_To_LDF_File\DB_NAME.ldf'

Make sure to edit the fields to the correct names and paths for your environment.