SQLTeam.com | Weblogs | Forums

Restore in SQL2019 a backup created in SQL2000

Records from a table in SQL2019 are missing prior to 2004, I found backups created in SQL2000.

I tried to installed SQL2000 in my computer Windows 11, however I am getting errors such as:

The ordinal 1 couldn't be located in the dynamic link....

Thanks,

Norbert

I think SQL2000 will restore into SQL2008 which you can then backup and restore into SQL2019. You could try creating a temporary VM with the following evaluation editions. I seem to remember the evaluation editions played havoc with the registry hence the recommendation to use a temporary VM.

https://www.microsoft.com/en-US/download/details.aspx?id=1279