for more information see here: http://dbathings.com/troubleshoot-microsoft-sql-server-error-code-3241/ share|improve this answer edited Sep 17 at 16:23 Jason Clark 424222 answered Apr 16 '12 at 5:25 Deepak 711 add a comment| up vote 1 How to make files protected? Report a bug Atlassian News Atlassian current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Security Patch SUPEE-8788 - Possible Problems? check over here
share|improve this answer answered Mar 16 '13 at 9:27 okkko 16829 add a comment| up vote 0 down vote In my case, the backup file was compressed, but the file extension So, I restored the database on a SQL Server 2008 machine. RESTORE HEADERONLY is terminating abnormally. But when you run the SQL Server Installation again, it will show you what instances are already installed, and prompt you for a new instance name for a new installation. https://support.microsoft.com/en-us/kb/2849351
All Rights Reserved. Does this Warlock ability combo allow the whole party to ignore Darkness? 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
I had no idea my SQL Mgmt Studio 2008 is connected to 2005 instance! –Ani Apr 16 '14 at 6:36 add a comment| up vote 4 down vote This type of Thanks. 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. Restore Headeronly Is Terminating Abnormally Error 3013 SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) Cause: The backup file was corrupted due to file uploaded using FTP Text Mode.
gallery.technet.microsoft.com/… hopefully I will be able to simulate the tables so I can recover the data using SSIS. Microsoft Sql Server Error 3241 Restore Headeronly Is Terminating Abnormally Email us Powered by Atlassian Confluence 5.8.10, Team Collaboration Software Printed by Atlassian Confluence 5.8.10, Team Collaboration Software. 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 browse this site There are two possible causes for this error:This error arises if you attempt to restore a database from a backup created on a later version of SQL Server to an earlier
How to emulate register_globals in PHP 5.4 During our recent Linux server migration task, we faced following strange issue: Some websites... The Media Family On Device Is Incorrectly Formed Sql 2014 Would you feel Centrifugal Force without Friction? In this case your options are limited share|improve this answer edited Apr 27 '15 at 13:12 answered Apr 26 '15 at 22:17 Jaco 606210 I found this .bak recovery Related: Restore SQL Server 2012 backup to a SQL Server 2008 database?
Not the answer you're looking for? It had solved my problem. Error No 3241 Sql Server Browse other questions tagged sql-server sql-server-2008 sql-server-2012 or ask your own question. The Media Family On Device Is Incorrectly Formed Sql 2008 Username: Password: Save Password Forgot your Password?
Blog Archive ► 2016 (1) ► April (1) ► 2015 (4) ► June (2) ► May (1) ► April (1) ► 2014 (10) ► November (3) ► September (1) ► July check my blog SQL Server instances are totally independent of one another, and you can basically install as many as you like - you just have to make sure to use unique instance names It will work Source: http://dotnetguts.blogspot.in/2010/06/restore-failed-for-server-restore.html share|improve this answer answered Mar 21 '12 at 13:58 SmartestVEGA 1655 add a comment| up vote 1 down vote If you're restoring a SQL Server 2008 asked 4 years ago viewed 7709 times active 4 years ago Related 7How to restore multiple backups4Restore script in SQL server doesn't work in W72Restoring database always throwing exception1Restore database created The Media Family On Device Is Incorrectly Formed Sql 2005
Era a versão do SQL que estava utilizando.Thanks!!! Thanks for sharing ... Toggle navigation Home Announcements Knowledgebase Network Status Affiliates Contact Us Account Login Register ----- Forgot Password? http://intelishade.net/sql-server/microsoft-odbc-sql-server-driver-tcp-ip-sockets-specified-sql-server-not-found.html Related 1Error when restore sql database from .bak file19How do you backup and restore a database as a copy on the same server?2Can’t restore SQL Server 2000 backup to SQL Server
Not the answer you're looking for? Restore Headeronly Is Terminating Abnormally Error 3201 Come on over! Linux Shared Hosting With Linux Shared Hosting, we allow sending emails without SMTP...
Warm Winter Muff Bash command to copy before cursor and paste after? How to write name with the letters in name? I think your only option here would be to script out your database (schema and data) and execute that against your 2005 instance. Sql Server Cannot Process This Media Family 2012 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
share|improve this answer answered Mar 14 '14 at 21:00 user2566365 111 add a comment| up vote 0 down vote My guess is that you are trying to restore in lower versions Featured On thewebhostingdir.com - a VPS Hosting Directory Language: ArabicAzerbaijaniCatalanCroatianCzechDanishDutchEnglishEstonianFarsiFrenchGermanHebrewHungarianItalianNorwegianPortuguese-brPortuguese-ptRomanianRussianSpanishSwedishTurkishUkranian × Activation Activation Request has been sent. × Welcome to AccuWeb Hosting Live Chat Based on what you want to discuss, I have been reading a lot about this and everything indicates that it is a SQL Server version related issue however I think it has something to do with how the My pictures come out bland: Should I change from Nikon to Canon?
Cyberpunk story: Black samurai, skateboarding courier, Mafia selling pizza and Sumerian goddess as a computer virus Resistors soldered 1cm off board Given a string, Return its Cumulative Delta SQL Server - Msg 3013, Level 16, State 1, Line 5 VERIFY DATABASE is terminating abnormally. Not the answer you're looking for? sql sql-server restore share|improve this question edited Aug 30 '12 at 13:32 ЯegDwight 17.4k93245 asked Jun 14 '10 at 13:43 Jordon Willis 2,04451633 3 Stop asking the same question stackoverflow.com/users/179123/jordon
Msg 3013, Level 16, State 1, Line 1 RESTORE HEADERONLY is terminating abnormally. http://dotnetguts.blogspot.com/2010/06/restore-failed-for-server-restore.html 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 SQL Server - How can varbinary(max) store > 8000 bytes? This might be the only supported option if you're trying to go from newer SQL Server to older version.
For example, if you are restoring across a network, the SQL Backup Agent service must have read permission to access the folder containing the backups. Are you restoring to the same server, or a different server? How? Given a string, Return its Cumulative Delta Newton vs Leibniz notation Last Digit of Multiplications Got the offer letter, but name spelled incorrectly How often do professors regret accepting particular graduate
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-05/02/2014: 01:43:43 December 27, 2013 at 1:20 AM Jesus Rdz said... The problem was however in insufficient rights. Click here to signup...