question

PrasantaKumarBiswas-4575 avatar image
0 Votes"
PrasantaKumarBiswas-4575 asked ErlandSommarskog answered

Could it be possible to restore the SQL Server 2005 database into the SQL Server 2019

I am using SQL Server 2005 from the year 2010. Now I am wishing to install SQL Server 2019 in the same machine. Is there any problem if I restore the previous version in new version ?

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered

AFAIK you need to make a migration step between to an other version, like 2012 before you can go on to 2019.
See Supported version & edition upgrades (SQL Server 2019) => Migration

"Backup and restore: A backup taken on SQL Server 2008 or SQL Server 2008 R2 can be restored to SQL Server 2019"
But not 2005 backups.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
1 Vote"
AmeliaGu-msft answered

Hi PrasantaKumarBiswas-4575,

Welcome to Microsoft Q&A.
In addition, you can use Data Migration Assistant (DMA) to help you migrate SQL Server 2005 database to SQL Server 2019.

117347-image.png

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. Please refer to Data Migration Assistant.
Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



image.png (81.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
2 Votes"
ErlandSommarskog answered

I need to correct Olaf. You can restore a database from SQL 2005 on SQL 2019. I just tested this.

Only if you have a database from SQL 2000, you need to go by an intermediate version, either SQL 2005 or SQL 2008.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.