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.