|
|
|
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 7:45 PM
Points: 2,039,
Visits: 639
|
|
Good point, I hadn't considered the size limitation.
Jamie
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, February 14, 2012 9:13 AM
Points: 341,
Visits: 1,492
|
|
Error messages when restoring from newer version of a backup file to older versions:
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.
So either the backup file is from SQL Server 2008, or its corrupted, in which case, you could ask your client to check that the original backup file is valid, generate a file checksum (md5) and compare the checksum against that generated on the copied file.
Ray Mond
RESTORE VERIFYONLY - don't bet your job on it! Learn why here.
TLogInfo - the only FREE tool to analyse your transaction logs. Download here.
SQLBakReader - the only FREE tool to inspect your SQL Server backup files without using SQL Server. Download here.
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, February 14, 2012 9:13 AM
Points: 341,
Visits: 1,492
|
|
You could also download the free SQL Server backup file reader (SQL BAK Reader) that can read details of SQL Server backup files without needing to install the correct version of SQL Server, or any version of SQL Server for that matter. Check the 'Software version major' value for your backup file to see if it's a SQL Server 2008 file.
You can download the application using this URL:
http://www.yohz.com/misc/SQLBAKReader.zip
Ray Mond
RESTORE VERIFYONLY - don't bet your job on it! Learn why here.
TLogInfo - the only FREE tool to analyse your transaction logs. Download here.
SQLBakReader - the only FREE tool to inspect your SQL Server backup files without using SQL Server. Download here.
|
|
|
|
