title: Backup a database on a HDD with a different sector size
body: <p>In our development environment we have long been using a particular backup and restore script for each of our products through various SQL Server versions and different environment configurations with no issues.</p>
  
  <p>Recently we have upgraded to SQL Server 2012 as our standard development server with SQL Compatibility Level 2005 (90) to maintain support with legacy systems. Now we find that on one particular dev's machine we get the following error when attempting to backup the database:</p>
  
  <blockquote>
    <p>Cannot use the backup file 'D:\MyDB.bak' because it was
    originally formatted with sector size 512 and is now on a device with
    sector size 4096.  BACKUP DATABASE is terminating abnormally.</p>
  </blockquote>
  
  <p>With the command being:</p>
  
  <pre><code>BACKUP DATABASE MyDB TO  DISK = N'D:\MyDB.bak' WITH  INIT , NOUNLOAD ,  NAME = N'MyDB backup',  NOSKIP ,  STATS = 10,  NOFORMAT
  </code></pre>
  
  <p>The curious thing is that neither the hardware nor partitions on that dev's machine have changed, even though their sector size is different this has not previously been an issue.</p>
  
  <p>From my research (i.e. googling) there is not a lot on this issue apart from the advice to use the <code>WITH BLOCKSIZE</code> option, but that then gives me the same error message.</p>
  
  <p>With my query being:</p>
  
  <pre><code>BACKUP DATABASE MyDB TO  DISK = N'D:\MyDB.bak' WITH  INIT , NOUNLOAD ,  NAME = N'MyDB backup',  NOSKIP ,  STATS = 10,  NOFORMAT, BLOCKSIZE = 4096
  </code></pre>
  
  <p>Can anyone shed some light on how I can backup and restore a database to HDDs with different sector sizes?</p>