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:
Now add the new file for taking backup and ok
That's it simple. Just remove the old backup file with different sector size.
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.