Gaurav Singh

Gaurav Singh

  • NA
  • 0
  • 25.5k

Problem Restoring Database back up.

Oct 17 2015 4:50 PM
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. 
 

Answers (1)