3241 Error Sql Server
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the
Sql Server 2005 Error 3241
workings and policies of this site About Us Learn more about Stack sql server 2008 error 3241 Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Sql Server 2008 Express
Jobs Documentation Tags Users 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 sql server error 3241 on restore them; it only takes a 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 microsoft sql server error 3241 occurred while executing a Transact-SQL statement or 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 Da
page covers SQL Backup Pro versions 7.0 to 7.7, which is not the lastest version. Help for other
Microsoft Sql Server Error 3241 Restore Headeronly Is Terminating Abnormally
versions is also available. Attachments (0) Page History Restrictions Page error 3241 sql server 2008 r2 Information Resolved comments Link to this Page… View in Hierarchy View Source Export to PDF
Sqlserver 3241
Export to Word SQL Backup 7 … SQL Backup Pro 7 documentation Errors and warnings SQL Server errors SQL Server error 3241 - The media family http://stackoverflow.com/questions/3037682/restore-db-error-restore-headeronly-is-terminating-abnormally on device ... is incorrectly formed Skip to end of metadata Created by Administrator, last modified by Marianne Crowder on Mar 07, 2013 Go to start of metadata When restoring a database, the following error may occur: SQL error 3013: RESTORE FILELIST is terminating abnormally.SQL error 3241: The media family on device https://documentation.red-gate.com/display/SBU7/SQL+Server+error+3241+-+The+media+family+on+device+...+is+incorrectly+formed
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have http://dba.stackexchange.com/questions/15342/restoring-a-database-is-not-working Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators 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 sql server database skills and learn 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 Restoring a database is not working up vote 6 down vote favorite I have a database called sql server 2008 FDB. I have created this database on my PC with SQL Server Express Edition and added one table. I made a backup of this database. The SQL Server version on the server is 2005. I copied this backup to the server and tried to restore it, but I get this message: The media family on device C:\Program File\Microsoft SQL Server\MSSQL.1\MSSQL\Bacup\FDB.bak is incorrectly formatted. SQL Server cannot process this media family. RESTORE Headeronly is terminating abnormally. Microsoft SQL Server error 3241 sql-server restore share|improve this question edited Mar 21 '12 at 18:45 Nick Chammas 8,958115591 asked Mar 21 '12 at 13:55 Pinchas K 13314 migrated from stackoverflow.com Mar 21 '12 at 14:11 This question came from our site for professional and enthusiast programmers. Are you restoring to the same server, or a different server? If it's a different server, make sure that it's the same version. –DForck42 Mar 21 '12 at 15:43 add a comment| 3 Answers 3 active oldest votes up vote 5 down vote accepted If yo