Post reply

Quick Question on 2019 to older version?

  • May 18, 2022 at 5:07 pm

    #4035122

    A client of ours is upgrading their database to SQL Server 2019.

    The edition of the SQL server that these database backups are currently being automatically restored to is SQL Server 2016.   I was wondering if anyone knew if its possible to restore a 2019 backups to a 2016 server without changing the compatibility level before its sent (also assuming the backup isnt compressed)?

    I don't have a 2019 server in my environment to test this with currently so thought I'd hit up you fine gentlemen.

  • May 18, 2022 at 5:11 pm

    #4035123

    You cannot restore a 2019 database to a 2016 server even if you're in the 2016 compatibility mode on the 2019 server.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 18, 2022 at 6:46 pm

    #4035167

    Thank you sir I appreciate it.

  • May 18, 2022 at 8:19 pm

    #4035203

    In fact, you cannot restore any newer-version SQL Server db to any older-version SQL instance, period.  Just does not work.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • May 24, 2022 at 10:10 pm

    #4038645

    Well....there's always a way.  The way you are looking for here is exporting it as a bacpac and then importing it into the 2016 server.  It's not nearly as nice a process as the backup restore process you probably already have automated, but it is possible.

     

  • May 25, 2022 at 2:54 am

    #4038719

    thebody wrote:

    Well....there's always a way.  The way you are looking for here is exporting it as a bacpac and then importing it into the 2016 server.  It's not nearly as nice a process as the backup restore process you probably already have automated, but it is possible.

    I've never tried that and haven't had the need to do so but thanks for the tip.  I didn't know such a thing would work.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply