I get an SQL error when I try to restore a back up of my database.

Do not try to restore your Database over the network or a mapped drive. You need to have your back up on a local drive. The path to that file is limited by SQL Server Restoration Process restrictions.