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 [...]