Restore SQL Server 2000 Database to SQL Server 2008
In 2005, I backed up a SQL Server 2000 database with a prior version of Backup Exec. Since then SQL Server was upgraded to 2005, then to 2008, and Backup Exec was upgraded to 2012 with several interim versions I'm sure. So I still have my backup tape with this backup on it, but now when I try to restore it, I get the following error:
The job failed with the following error: The selected database appears to have been backed up from a newer version of SQL Server. Backups made from newer versions of SQL Server cannot be restored to older versions of SQL Server.
But it's not from a newer version of SQL Server, it's from an old version.
So now what? What's the point of backups if you can't restore old ones?