I am using SQL Server express 2014 Management Studio.
I am having issue with restoring AdventureWorksDW2014.bak and AdventureWorks2014 .bak.
While i tried to restore it using GUI i got " No backupset selected to be restored " message, and with Query
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\AdventureWorks.BAK'
I got following message.
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\AdventureWorks.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I would appreciate the help. Thank you.