| |
 |
You
cannot restore a backup created with a newer version of SQL Server
on an instance running an older version of SQL Server.
Unfortunately, the error messages that are displayed may not always
tell you that it is a versioning problem. These are some of the
error messages raised when trying to restore a backup file that is
not backwards compatible.
SQL Server 2008 R2 to SQL Server 2008
Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 10.50.1600.
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.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. |
SQL Server 2008 R2 to SQL Server 2005
Server: Msg 3241, Level 16, State 7, Line 1
The media family on device 'f:\temp\test001_sql2008r2.bak' is
incorrectly formed. SQL Server cannot process this media
family.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. |
SQL Server 2008 R2 to SQL Server 2000
Server: Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 661. The
server supports version 539 and cannot restore or upgrade this
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. |
SQL Server 2008 to SQL Server 2005
Server: Msg 3241, Level 16, State 7, Line 1
The media family on device 'f:\temp\test001_sql2008.bak' is
incorrectly formed. SQL Server cannot process this media
family.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. |
SQL Server 2008 to SQL Server 2000
Server: Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 655. The
server supports version 539 and cannot restore or upgrade this
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. |
SQL Server 2005 to SQL Server 2000
Server: Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 611. The
server supports version 539 and cannot restore or upgrade this
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. |
Discuss or comment on this article on our Facebook group.
Document history
| 8/13/2010 | Initial release. |
|
