A client has given me a backup (.bak) from a SQL Server v 7 database. I am trying to load it into version 10 which is incompatible. Are there any tools that will restore or prepare an old version backup to be restored into version 10?
EDIT: Per request, here is the text from the error dialog
The database was backed up on a server running version 7.00.1063. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3169)
Best Answer
You can restore a SQL 7 backup on a SQL 2005 instance, then backup/restore or detach/attach to SQL 2012 or 2014. "version 10" is SQL 2008, so you wouldn't want to stop there, probably. You can get old installs of SQL from MSDN Subscriber Downloads, or the Express Edition is still available for download.