Cannot use the backup file ‘%ls’ because it was originally formatted with sector size %d and is now on a device with sector size %d.

Details
Product: SQL Server
Event ID: 3268
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Cannot use the backup file ‘%ls’ because it was originally formatted with sector size %d and is now on a device with sector size %d.
   
Explanation
SQL Server uses nonbuffered I/O, which requires sectors to be aligned. The backup file was taken on a system with a different physical block size than the current server, or the WITH BLOCKSIZE clause was used in the RESTORE command. On Windows 2000-based computers, the default block size is 65,536 (64 KB, which is the maximum size SQL Server supports). For more information about this error, see “Troubleshooting Backing Up and Restoring” in Book Online.
   
User Action
You must restore the backup set from a disk with the same sector size, or over a network, which uses buffered I/O. Alternatively, you can specify a WITH BLOCKSIZE clause to set the physical block size to the current server’s settings when you back up the database.

Related:

Leave a Reply