Acronis Backup SQL server Image Restore in other hardware getting Error message
SQL Server backup HDD Image with Universal License Acronis, after Restoring in other Hardware Server following Error Message Please any body can help.
System.Data.SqlClient.SqlError: Cannot use the backup file 'E:\POS Daily Backup\POS_backup_2017_09_01_010003.bak' because it was originally formatted with sector size 512 and is now on a device with sector size 4096. (Microsoft.SqlServer.Smo)
The error message is generated by SQL Server Management Studio upon attempt to use the old backup of your SQL Server database created with the help of SQL Server Management Studio.
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).
After you have removed the existing backup file on SQL Server Management Studio (SSMS) add the new one backup file.
Next backup will succeed.