locked
SQL 2008 R2 database restore RRS feed

  • Question

  • Is it possible to restore a database that resides on SQL Server 2008 R2 SP2 onto a newer version of SQL like SQL Server 2016.

    ----E----

    Friday, November 18, 2016 3:30 PM

All replies

  • Hello,

    Yes, in common SQL Server is 3 version backward compatible, means on SQL Server 2016 you can restore backups from 2014, 2012 and 2008 / 2008 R2


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by AV111 Sunday, November 20, 2016 10:57 AM
    Friday, November 18, 2016 3:35 PM