If the data files are in a different location, you need to specify the MOVE option also:
RESTORE DATABASE yourDatabaseNameHere
FROM DISK = 'x:\full\path\to\backup\backup.bak'
WITH MOVE 'logical_data_file_name'
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb. Luckily, there is a free version SQL Express, but does …