Cry about...
SQL Server Troubleshooting
Restore terminating: The server supports version NNN ...
Symptom:
A restore operation fails with the message:
The backed-up database has on-disk structure version NNN. The server supports version YYY and cannot restore or upgrade this database.
Backup or restore operation terminating abnormally.
For example with NNN=539 and YYY=515.
Cause:
The database that is being restored is a later version than the current.
This error has been observed when trying to restore a database backed up from SQL Server 2000 onto a system with SQL Server 7.
Remedy:
Restore with the same version of SQL Server as the original backup was taken.
These notes are believed to be correct for SQL Server 7 and may apply to other versions as well.
About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.