This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hello,
I have recently installed Sql server 2022 express and Configured Log shipping on both Primary and Secondary server which currently running fine both the DB but somehow I need to rollback to Sql Server 2019.
What's the best way I can revert it back?
I know that I can't use SQl server 2022 backup and restore into Sql Server 2019 but can get the original backup previously taken from old server which is lower version of sql server and restore into new Sql Server 2019.
Database is smaller size.
Is it I have to uninstall Sql 2022 and reinstall Sql 2019 then restore the DB and Reconfigure Log shipping?
If anyone have other detail steps that will be great too!
Thanks for your help!
Hi @pdsqsql,
You could not directly roll back from SQL 2022 to SQL 2019.
You need to uninstall the SQL Server 2022 and use the SQL 2019, restore the backup you have in SQL 2019.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Thanks Zoe.
I know Sql Server doesn't support back word compatibility to restore DB from higher edition to lower edition of sql server.
I ma just looking any better way as I have to configure Logshipping too?
I need to rollback to Sql Server 2019.´What's the best way I can revert it back?
SQL Server database files/backups are not backward compatible and so there is no easy way to rollback to a older SQL Server version.
You have to uninstall 2022 and re-install 2019. Then you can use the older 2019 backup to recreate the user databases; 2022 can't be used.
Why haven't you tested the upgrade before in a test enviroment? And normal one have a rollback plan for such a scenario.
Thanks Olaf.
I know Sql Server doesn't support back word compatibility to restore DB from higher edition to lower edition of sql server.
I ma just looking any better way as I have to configure Logshipping too?
I ma just looking any better way
There is no "better way" then the one we provided here.
Thanks Olaf.
Thank you!
Is it Data Migration Assistant (DMA) will be ok to use restore into Primary and secondary then turn on logshipping?
I am thinking to use DMA first to restore database into Primary from the old/current to server to new server ( I will turn off log backup/restore job of Logshipping during this outage) and then from New Primary to New Secondary server I will restore the database and turn on Logshipping job to compalete the migration process will be ok this approach?