asked on Restoring a 2008 backup to a 2014 database
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
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!
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
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!
Microsoft SQL Server 2008Microsoft SQL Server
Last Comment
Starr Duskk
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I found it:
To view or change the compatibility level of a database
1.After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name.
2.Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
3.Right-click the database, and then click Properties.
The Database Properties dialog box opens.
4.In the Select a page pane, click Options.
The current compatibility level is displayed in the Compatibility level list box.
5.To change the compatibility level, select a different option from the list. The choices are SQL Server 2008 (100), SQL Server 2012 (110), or SQL Server 2014 (120).
To view or change the compatibility level of a database
1.After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name.
2.Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
3.Right-click the database, and then click Properties.
The Database Properties dialog box opens.
4.In the Select a page pane, click Options.
The current compatibility level is displayed in the Compatibility level list box.
5.To change the compatibility level, select a different option from the list. The choices are SQL Server 2008 (100), SQL Server 2012 (110), or SQL Server 2014 (120).
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Great.
SQL Server 2014 doesn't know databases previous than SQL Server 2008 even if they are attaché in a SQL Server 2008 instance. The compability need to be set at 10 at minimum to be recognized by MSSQL 2014.
SQL Server 2014 doesn't know databases previous than SQL Server 2008 even if they are attaché in a SQL Server 2008 instance. The compability need to be set at 10 at minimum to be recognized by MSSQL 2014.
ASKER
I also noticed this:
I had created an admin user and logged in as that. The button to run the restore was missing. I had to use the script. that did work.
But when I logged in as the Administration user that was created by Rackspace, the button was there.
so there is likely something missing from my created admin user that the original admin user has.
thanks!
I had created an admin user and logged in as that. The button to run the restore was missing. I had to use the script. that did work.
But when I logged in as the Administration user that was created by Rackspace, the button was there.
so there is likely something missing from my created admin user that the original admin user has.
thanks!
ASKER
thanks!
thanks!