Social Icons

Sunday, 12 November 2017

Sql Server - Fix Error - Can not use the backup file because it was originally formatted with 512 and is now on a device with sector size 4096

Recently i encountered Sql Server Error when i try to take backup of database from SSMS (Sql Server Management Studio) i.e

System.Data.SqlClient.SqlError : can not use the backup file "path" because it was originally formatted with sector size 512 and is now on a device with sector size 4096



Solution:


 Problem is , backup file which was created with different sector size , so it is not possible now to use it. So solution is remove that backup file 



Now add the new file for taking backup and ok


That's it simple. Just remove the old backup file with different sector size.



No comments:

Post a comment

Please Give your Valuable Suggestions,Questions and Comments to improve my blog.