Hi, you should be able to restore a .BAK file to any newer version of SQL Server. Typically this error is hit when you try to restore to a lower version (ex: onto SQL Server 2000).
How are you trying to restore the DB? From SSMS, you can right-click on the database node –> All Tasks –> Restore Database –> From Device –> Select Devices –> Add your .bak file. Click OK.
You may need to change the logical/physical file names if it was backed up from a different server. To do this, click the Options tab. On the left side you should see the Logical file name of the database from the .bak file. The right side label
‘Move to physical file name’ should be the path that the .bak file originally existed as. This field needs to be changed to the path & file name of the database you’re restoring to. After modifying those two fields, check the ‘Force restore over
existing database’ and click ‘OK’.
Sam Lester (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.