Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Want to restore a bak 2014 file on 2008 r2 lower

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2015-01-21 : 19:28:20
I want to restore a bakup file of db created on sql server 2014 version.

On Sql server 2008 R2. i am having issues.

Is it possible to restore on a lower version.

Are there any options available.

Thanks a lot for the helpful info.

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2015-01-22 : 07:41:51
you cannot restore to a lower version.
One alternate would be to generate scripts on the source and execute them on the destination.

Javeed Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95
Go to Top of Page
   

- Advertisement -