3241 Sql Server Restore Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
Sql Server Error 3241 Restore Headeronly
policies of this site About Us Learn more about Stack Overflow the company microsoft sql server error 3241 restore headeronly is terminating abnormally Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users error 3241 sql server 2005 Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a
Error 3241 In Sql Server 2008
minute: Sign up Restore DB — Error RESTORE HEADERONLY is terminating abnormally. up vote 27 down vote favorite 1 I have taken backup of SQL Server 2008 DB on server, and download them to local environment. I am trying to restore that database and it is keep on giving me following error. An exception occurred while executing a Transact-SQL statement or
Error 3241 Sql Server 2008 R2
batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: The media family on device 'C:\go4sharepoint_1384_8481.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476 I have tried to create a temp DB on server and tried to restore the same backup file and that works. I have also tried no. of times downloading file from server to local pc using different options on Filezila (Auto, Binary) But its not working. After that I tried to execute following command on server. BACKUP DATABASE go4sharepoint_1384_8481 TO DISK=' C:\HostingSpaces\dbname_jun14_2010_new.bak' with FORMAT It is giving me following error: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup\ C:\HostingSpaces\dbname_jun14_2010_new.bak'. Operating system error 123(The filename, directory name, or volume label syntax is incorrect.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. After researching I found the following 2 useful links: http://support.microsoft.com/kb/290787 http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/4d5836f6-be65-47a1-ad5d-c81caaf1044f But I am still not able to restore Database correctly. Any help would be much appreciated. Thanks. sql sql-server restore share|improve this question edit
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the media family on device is incorrectly formed sql 2008 the workings and policies of this site About Us Learn more about
The Media Family On Device Is Incorrectly Formed Sql 2005
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators restore headeronly is terminating abnormally error 3013 Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn http://stackoverflow.com/questions/3037682/restore-db-error-restore-headeronly-is-terminating-abnormally from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top media family on device is incorrectly formed. SQL Server cannot process this media family up vote 17 down vote favorite 5 I http://dba.stackexchange.com/questions/37288/media-family-on-device-is-incorrectly-formed-sql-server-cannot-process-this-med am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot process this media family. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. I have tried restoring using 2012, 2008 and even 2005 but nothing works, I have used the following query and through the Tasks >> Back up but nothing works, here's my SQL: RESTORE DATABASE JA FROM DISK='c:\glyn\JA.bak' Does anyone have any suggestions? I've read that the bak could be corrupt, it was sent to my by another developer on DVD who is working on the project. backup restore share|improve this question edited Mar 22 '13 at 15:55 Serg 14113 asked Mar 21 '13 at 20:57 Funky 186114 add a comment| 4 Answers 4 active oldest votes up vote 5 down vote I found this that says that your backup file is corrupted. Possibly transfered by FTP in text mode rather than binary. And
| .Net 3.0 | ASP.Net | C#.Net | SQL | Errors | Tricks | Code | VS.Net | Optimization | Subscribe Search This Blog Examples http://dotnetguts.blogspot.com/2010/06/restore-failed-for-server-restore.html Loading... Sunday, June 27, 2010 Restore failed for Server - RESTORE HEADERONLY is terminating abnormally Recently I haveupgraded my database from SQL Server 2005 Express to SQL Server 2008 Express, and I have notice on restoring database it started giving me following restore error. Error Details An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: The media family on device sql server 'C:\NorthwindDB.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476 Few things you should try before going for solution This error can occurs due to many reasons but you must ensure following before you start for any solution, it would save your lot of time. 1) Ensure Backup copy of 3241 sql server Database is good. - Take a backup and store on machine where you tried to take backup. - Now create one dummy database and try to restore that database. - If you are able to restore that database successfully on machine backup was created,than your backup copy is good. You should alternately try taking backup using following command BACKUP DATABASE NorthwindDB TO DISK='C:\HostingSpaces\MyBackupCopy_NorthwindDB.bak' with FORMAT If you are able to take backup successfully than Backup copy is good. 2) Ensure Backup copy doesn't get corrupted during dowload. In my case, I have created a backup copy on Hosting Server, than stored it in .Zip Format, and than try to download it using FileZila, with default settings of filezila transfer type, i.e. Auto. Till this point everything was going good, but still I was not able to restore DB. 3) Important : Open SQL Query window and check version of your SQL Server. Run following command and see the output. Select @@Version It had given me following output Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6002: Service