Here is a recent email which I received from Madhu. He is a beginner in the SQL Server and when he tried to take a backup from SSMS (SQL Server Management Studio), he got error related to backup file. As soon as he sent me an email I knew what was the exact problem, he was facing and I was able to help him quickly. Let us first recreate the same error and later on see how to fix the same.
When he tried to take backup of his database, he received following error:
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)
You can see in the following image the error window in SSMS.
Well, the solution for the same is very easy.
Solution / Workaround:
The reason for the error is that the backup file which was created was created with different sector size and it is not possible to use it now. In the SSMS we can see there is already one file in the Destination.
First remove the existing file in SSMS.
Next, add a new file to the backup location.
That’s it! We are done!
Reference: Pinal Dave (https://blog.sqlauthority.com)