Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Problem Restoring Database back up.
Gaurav Singh
Oct 17 2015 4:50 PM
2.4k
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
how to get in different way
Network instance error