I eventually managed to get this sorted with the SQL below:

RESTORE DATABASE AdventureWorks FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\AdventureWorks2014.bak' WITH FILE = 1,

MOVE N'AdventureWorks2014_Data' TO N'C:\Program Files\Microsoft SQL...