Backup a database on a HDD with a different sector size

sql sql-server tsql sql-server-2012 backup

All you have to do is back it up with a different name.

sql sql-server tsql sql-server-2012 backup

This issue is caused by different sector sizes used by different drives.

You can fix this issue by changing your original backup command to:

BACKUP DATABASE MyDB TO  DISK = N'D:\MyDB.bak' WITH  INIT , NOUNLOAD ,  NAME = N'MyDB backup',  STATS = 10,  FORMAT

Note that I've changed NOFORMAT to FORMAT and removed NOSKIP.

Found a hint to resolving this issue in the comment section of the following blog post on MSDN:SQL Server–Storage Spaces/VHDx and 4K Sector Size

sql sql-server tsql sql-server-2012 backup

Just remove the existing .bak file and re-run.

CodeHunter