Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

The best way to backup your SQL Server databases is to use SQLBackupAndFTP. But if you still backup your SQL Server database with the help of SQL Server Management Studio you can face with the following issue. Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512. Before to solve this case let’s recreate the same error message.During the backup process, you can receive this error message:

System.Data.SqlClient.SqlError: Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512. (Microsoft.SqlServer.Smo)

Here is the screenshot with the error message:  Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512 Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512Well, the resolution of this issue is very simple, let’s start:

Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512 – Solution

The reason that you have received this error message is that the backup file was created with the different sector size. As it was created with the different sector size there is no way to use it. So the solution is very simple, all you need to do is remove the existing backup file on SQL Server Management Studio (SSMS).
Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

After you have removed the existing backup file on SQL Server Management Studio (SSMS) add the new one backup file.Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

Let’s try to make the backup one more time.  Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

That’s all. As you can see, the solution to this issue is very simple and takes about few  minutes. In order to avoid similar error messages in the future, we highly recommend you to make SQL Server database backups automatically with the help of SQLBackupAndFTP.

Here you can find the short tutorial how to create a backup job.

[Total: 1    Average: 5/5]