• SequelDBA (4/27/2015)


    I have a SQL 2014 Express instance that a developer installed. Currently, we do not "officially" support SQL 2014. I want to move the 2014 database to a 2012 consolidated instance. Can I backup/restore a SQL 2014 database to a SQL 2012 instance?

    Thank you...

    You'll get a lot more people viewing your question if you were to open a new thread. The only people likely to see this are the ones who have posted or subscribed to this thread.

    But, to answer your question, no. You can't. There are structural changes in how the data is stored and how backups are generated that makes it impossible to restore a backup within SQL Server from a higher version to a lower version. You'll need to migrate the data using SSIS, bulk load processes, or a third party tool.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning