troubleshooting Question

Restoring a 2008 backup to a 2014 database

Avatar of Starr Duskk
Starr DuskkFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
7 Comments2 Solutions148 ViewsLast Modified:
I am restoring a 2000 dbf to a 2008 dbf. Then I am taking that 2008 dbf backup and restoring it to a 2014 database.

I have successfully restored the 2000 to a 2008. Then from there I made another backup copy and put it on the machine with the 2014.

When I go to Right click "Restore database" it brings up the screen.

I set my Source as "Device" and put in the path to the .bak file for the 2008.

Then my destination I filled in with the name of the dbf from the 2008. All looks good.

I check the box next to "Backup sets to restore" for "Restore."

Then the ONLY button that shows at the bottom is: "Verify Backup Media."
I click that and it says "Done"
But no restore.

I go to the "Files" tab and check the box for "Relocate all files to folder" and it has the path set to the data:

C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA
Same for log file.

I go to Options and see nothing special there to check or uncheck.

I do not find a button that specifically allows me to restore. What do I do now? Nothing happens.

Starr Duskk
ASP.NET VB.NET Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros