Tip: Restoring SQL Database from a network location

Just a quick tip if you wanted to restore a SQL database from a network location as opposed to  your local file structure.

This is a restriction for SQL management studio and sometimes a real pain when working with virtual images.

When entering the location of the file, make sure you use the full UNC path. e.g. 

"\\ComputerName\Shared folder\Backup\myremostsqlbackup.Bak"

SQL management studio will not have a problem with this and will backup too or restore the file :)

Thanks

Jonathan