Skip to main content

Acronis Backup SQL server Image Restore in other hardware getting Error message

Beginner
Posts: 1
Comments: 0

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)

 

 

 

Forum Star
Posts: 58
Comments: 2184

Top

Hi,

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. 

image

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).

image

After you have removed the existing backup file on SQL Server Management Studio (SSMS) add the new one backup file.

image

Next backup will succeed.

image