Share via

Problemas com versão do SQL server

TI HPF 0 Reputation points
2024-10-18T19:08:21.7833333+00:00

Tenho um servidor executando o SQL Server 2016 Standard Edition e estou precisando voltar um backup nele mas está dando divergência nas versões, como faço para realizar a atualização que aceitaria o meu Backup anterior?

WhatsApp Image 2024-10-17 at 09.40.01

WhatsApp Image 2024-10-17 at 11.24.10

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,864 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 111.8K Reputation points MVP
    2024-10-18T21:43:36.5866667+00:00

    This is the English part of Microsoft Q&A. For questions in Portoguese, I suggest that you go to https://learn.microsoft.com/pt-br/answers/questions/ask/.

    You cannot restore a backup from an newer version of SQL Server to an older. You need to install SQL 2019 to restore that backup. If you want that database on your SQL 2016 instance, you need to script it and copy the data manually. Beware that the database may be using features not supported on SQL 2016.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.