Solved

Having problem restoring the Adventure Works sample database I downloaded

Posted on 2014-10-07
3
376 Views
Last Modified: 2014-10-08
Hi,
I'm using SQL2012.  I selected the device but no Database is shown in the dropdown and the OK button stays disabled.  On the top left it also shows error message or "No backupset selected to be restored).  How can I fix this?  Thanks.
DB-restore.jpg
0
Comment
Question by:lapucca
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40367742
Did you realize that you are trying to restore the version for SQL Server 2014 and not for 2012? Just check the filename.
0
 

Author Comment

by:lapucca
ID: 40368722
Ha!  Lol...  That's brilliant!  thank you and I will download the correct 2012 and try.
0
 

Author Closing Comment

by:lapucca
ID: 40368723
Thank you.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question