|
|
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. |
Document history
8/13/2010 | Initial release. |
|