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.

thanks!
ASKER CERTIFIED SOLUTION
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