Cry about...
SQL Server Troubleshooting

Restore terminating: The server supports version NNN ...


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.


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.


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: 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.