TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Gaurav Singh
NA
0
25.3k
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.
Reply
Answers (
1
)
how to get in different way
Network instance error