I have created a backup of a SQL database in SQL 2014 and want to use this backup to restore it to a different machine that also runs SQL 2014, hence no version issues. However, I keep receiving an error that the system cannot find the .mdf file. Once I have selected the backup file I receive the check mark that the database is ready to be restored but as soon as I click Ok the error appears. Error message below; the provided link to MSFT does not contain any information.
TITLE: Microsoft SQL Server Management Studio Restore of database 'BEWEBAPP' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\BEWEBAPP.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&LinkId=20476
Does this means that a backup can only be restored to the machine it was taken from?? Frankly, I do not understand why restoring a database has to be so difficult.
Any solution for this problem are well appreciated.