locked
Restore to SQL Server 2019 from SQL Server 2012 RRS feed

  • Question

  • Hi,

    Need to know how to restore to SQL Server 2019 from SQL Server 2012.
    Many thanks.

    Jason

    Thursday, April 16, 2020 8:59 AM

Answers

  • Backup the database on SQL Server 2012 and restore on SQL Server 2019, set compatibilty mode for restored database to 150

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Tom Phillips Thursday, April 16, 2020 10:59 AM
    • Marked as answer by JasonHuang8888 Friday, April 17, 2020 1:39 AM
    Thursday, April 16, 2020 9:05 AM
  • There is nothing special to consider when restoring a 2012 backup to SQL Server 2019, simply perform the restore: Restore a Database Backup Using SSMS

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Tom Phillips Thursday, April 16, 2020 10:59 AM
    • Marked as answer by JasonHuang8888 Friday, April 17, 2020 1:39 AM
    Thursday, April 16, 2020 9:05 AM
  • Hi Jason,

     In SQL Server 2019, you can restore a SQL Server 2005 or later user database backup.
    But upgrades from Earlier Versions to SQL Server 2019, you need at least SQL Server 2012 (11.x) SP4.

    Best Regards,
    Cris


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 16, 2020 10:13 AM

All replies

  • Backup the database on SQL Server 2012 and restore on SQL Server 2019, set compatibilty mode for restored database to 150

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Proposed as answer by Tom Phillips Thursday, April 16, 2020 10:59 AM
    • Marked as answer by JasonHuang8888 Friday, April 17, 2020 1:39 AM
    Thursday, April 16, 2020 9:05 AM
  • There is nothing special to consider when restoring a 2012 backup to SQL Server 2019, simply perform the restore: Restore a Database Backup Using SSMS

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Tom Phillips Thursday, April 16, 2020 10:59 AM
    • Marked as answer by JasonHuang8888 Friday, April 17, 2020 1:39 AM
    Thursday, April 16, 2020 9:05 AM
  • Hi Jason,

     In SQL Server 2019, you can restore a SQL Server 2005 or later user database backup.
    But upgrades from Earlier Versions to SQL Server 2019, you need at least SQL Server 2012 (11.x) SP4.

    Best Regards,
    Cris


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 16, 2020 10:13 AM