Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kwaedza
Starting Member
1 Post |
 Posted - 2013-06-14 : 09:01:15
|
| I want to restore a database but I am getting the following error, "The media family on device is incorrectly formed. SQL server can not process this media family. RESTORE HEADERONLY is terminating abnormally. Microsoft SQL server, Error: 3241".Kwaedza |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-07-29 : 05:58:57
|
| It looks like, you are getting error message due to a mismatch of SQL server versions between the backup and restore. Generally, you can't restore a backup created using higher version to lower version.Here is a Link that describing database versions and compatibility levels:http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/04/26/what-s-the-difference-between-database-version-and-database-compatibility-level.aspx |
 |
|
|
elliswhite
Starting Member
36 Posts |
Posted - 2014-05-02 : 01:43:43
|
| first confirm that u have taken backup of the transaction log file with main backup file, so that u can restore backup database easily from Microsoft sql server. For more help visit here: http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/ |
|
|
|
adsingh82
Starting Member
20 Posts |
|
|
adsingh82
Starting Member
20 Posts |
|
|
|
|
|
SQL Error 3241