1. Home
  2. Database
  3. SQL Server
  4. SQL Server Error Messages
  5. “Backup failed for Server…because it was originally formatted with sector size…”

“Backup failed for Server…because it was originally formatted with sector size…”

Summary

This Error Message Article explains the SQL Management Studio error message “Backup failed for Server ‘[server name]’.  (Microsoft.SqlServer.SmoExztended) Additional information: System.Data.SqlCLient.SqlError: Cannot use the ‘[backup file and file location]’ because it was originally formatted with sector size [sector size] and is now on a device with sector size [sector size] (Microsoft.SqlServer.Smo)” and details how to fix the underlying problem that caused it to appear.

Explanation

A backup file is attempting to be saved over another existing backup file. When the message appears, the original file needs to be removed before the new file can be saved. This probably is due to some change in the original file where SQL does not recognize it as the old file.

In the case where the message appeared, the database structure had been changed and it is possible a different version of SQL was used to generate the file. Either of those may have been the reason that SQL would not save the new backup over the old one.

Solution

A good workaround is to select ‘backup to a new media set’.  It seemed to solve the problem. In this situation, it was saving over a backup of a newer version of SQL.

Additional Comments

Error First Appeared: Windows 8 running Microsoft SQL Management Studio 2008

Other Helpful Links:

http://stackoverflow.com/questions/24285195/sql-server-2012-express-backup-database-failure

http://stackoverflow.com/questions/22448818/backup-a-database-on-a-hdd-with-a-different-sector-size

Updated on August 1, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support