title: Restore DB — Error RESTORE HEADERONLY is terminating abnormally.
body: <p>I have taken backup of SQL Server 2008 DB on server, and download them to local environment.</p>
  
  <p>I am trying to restore that database and it is keep on giving me following error.</p>
  
  <blockquote>
    <hr>
    
    <p>An exception occurred while executing
    a Transact-SQL statement or batch.
    (Microsoft.SqlServer.ConnectionInfo)</p>
    
    <p>------------------------------ ADDITIONAL INFORMATION:</p>
    
    <p>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)</p>
    
    <p>For help, click:
    <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=09.00.4053&amp;EvtSrc=MSSQLServer&amp;EvtID=3241&amp;LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=09.00.4053&amp;EvtSrc=MSSQLServer&amp;EvtID=3241&amp;LinkId=20476</a></p>
  </blockquote>
  
  <p>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)</p>
  
  <p>But its not working.  After that I tried to execute following command on server.</p>
  
  <pre><code>BACKUP DATABASE go4sharepoint_1384_8481 
  TO DISK=' C:\HostingSpaces\dbname_jun14_2010_new.bak' with FORMAT
  </code></pre>
  
  <p>It is giving me following error:</p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <p>After researching I found the following 2 useful links: </p>
  
  <ol>
  <li><a href="http://support.microsoft.com/kb/290787">http://support.microsoft.com/kb/290787</a></li>
  <li><a href="http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/4d5836f6-be65-47a1-ad5d-c81caaf1044f">http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/4d5836f6-be65-47a1-ad5d-c81caaf1044f</a></li>
  </ol>
  
  <p>But I am still not able to restore Database correctly.</p>
  
  <p>Any help would be much appreciated.  Thanks.</p>