|
Rank: Administration
Groups: Administrators, Registered
Joined: 8/10/2009 Posts: 437
|
You can NOT restore backups from a newer SQL version to an older - the formats of backup files are different. From http://msdn.microsoft.com/en-us/library/ms186858.aspx: "Backups created with Microsoft SQL Server cannot be restored to an earlier version of SQL Server" So 2008 to 2005 won't work, nor 2008 R2 to 2008. If you try you will get errors like: "The media family on device .. is incorrectly formed. SQL Server cannot process this media family" or "RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)". or "The backup of the system database on device .. cannot be restored because it was created by a different version of the server" Your options are: 1. upgrade the target SQL server to the same version as the source SQL server - this is the only long term solution. If you just need to restore once - see below. 2. use Import and Export Data Wizard (In SSMS right click on a database and select "Tasks > Export Data...") 3. use scripts (In SSMS right click on a database and select "Script Database as" or "Tasks > Generate scripts...") Note that setting compatibility level on a source server to a lower setting won't help - it just affects the T-SQL, not how DB stored.
|
|
Rank: Guest
Groups:
Joined: 8/10/2009 Posts: 1,022
|
https://www.dropbox.com/s/nlnhdjpnc0xj7b6/Cakeorder.bakI tried the above methods you have suggested but none worked. Can u please try to restore this file and the the restored files to my email. my email id - ashveenchamp@live.comThank You!!! https://www.dropbox.com/...jpnc0xj7b6/Cakeorder.bak
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011 Posts: 822
|
Hello, The media family is incorrectly formed. SQL Server cannot process this media family. Please use "Run RESTORE VERIFYONLY after backup" option to check .bak file just after backup. 
|
|
Rank: Guest
Groups:
Joined: 8/10/2009 Posts: 1,022
|
AlexP wrote:Hello, The media family is incorrectly formed. SQL Server cannot process this media family. Please use "Run RESTORE VERIFYONLY after backup" option to check .bak file just after backup.  I don't have the database to backup it up again. I only need the file restored. Can u please restore the Cakeorder.bak file and send me the database files to my email - ashveenchamp@live.comThank You!!!
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011 Posts: 822
|
No, we cannot due the error: Msg 3241, Level 16, State 0, Line 1 The media family on device '<path>\Cakeorder.bak' is incorrectly formed. SQL Server cannot process this media family. Msg 3013, Level 16, State 1, Line 1 VERIFY DATABASE is terminating abnormally.
|
|
Rank: Guest
Groups:
Joined: 8/10/2009 Posts: 1,022
|
Isn't there any other method to get the Cakeorder.bak file restored?? If someone can do it can u pls sendhttp://mysqlbackupftp.com/forum/resource.ashx?c=1 me the restored files to my email id - ashveenchamp@live.com
|
|
Rank: Advanced Member
Groups: Administrators, Registered
Joined: 12/23/2015 Posts: 457
|
Sorry, it seems there is no way to restore the database.
|
|
Rank: Newbie
Groups: Registered
Joined: 5/24/2017 Posts: 1 Location: Oregon USA
|
I have a .bak file I downloaded using Wondershare's MobileTrans from a LG K7 cell phone. LG-K330. I am trying to learn how to open this .bak file so I may print the text messages. It is only sms text messages in the .bak file. Do you have any suggestions? I tried the one click restore program and got this error message: Can't match logical files.Cannot open backup device. Which lists my file address here. Then says: Operating system error 5 (Access denied)RESTORE FILELIST is terminating abnormally.
I have SMSS I have the ms SQL Server Management Studio 17 but I don't know where to start. Do you have any ideas for me?
|
|
Rank: Advanced Member
Groups: Administrators, Registered
Joined: 12/23/2015 Posts: 457
|
Please try to solve this case with the help of the following blog post: https://sqlbackupandftp....error-5access-is-denied/
|
|