SQL: Restoring a SQL Server 2000 database on SQL Server 2022
You’d think SQL Server 2000 would be long gone by now, but recently I had to restore a SQL Server 2000 database, and get it working on SQL Server 2022.
Now extended support for SQL Server 2000 ended on 9th April 2013.
SQL Server 2000 came in several editions: Enterprise, Standard, Developer, Personal, and the Desktop Engine or MSDE. I’m guessing most people would forget that there was ever a Personal edition. Regardless, this database was from an application that used an embedded database attached to the Desktop Engine or MSDE.
2025-08-06