Details Product: SQL Server Event ID: 3269 Source: MSSQLServer Version: 8.0 Component: SQL Engine Message: Cannot restore the file '%ls' because it was originally written with sector size %d; '%ls' is now on a device with sector size %d.
Explanation SQL Server uses nonbuffered I/O, which requires sectors to be aligned. The database was originally created on a disk with nonstandard disks with nonstandard sector sizes. To restore this database, the database files must be located on compatible disks. For example, if the database log was originally created on a disk with a sector size of 4K, the backup must be restored to a disk with a sector size of 4K.
User Action Locate a disk with the required sector size and restore to that disk. You may need to use the WITH MOVE clause to direct RESTORE to use the desired disk.从微软的错误信息来看,根本就没有方法还原到磁盘扇区不同的磁盘上。
由于备份文件最初是用一个扇区大小格式化的而且现在处于另一个扇区的设备上,因此不能使用。 SQL Server 使用不含缓冲区的 I/O,要求扇区对齐。必须从具有相同扇区大小的磁盘还原备份集,或者通过网络,后者使用含有缓冲区的I/O。或者,可以在备份数据库时,指定一个 WITH BLOCKSIZE 子句。 转载请注明本帖出自中联IT社区 http://www.woxit.cn/,本贴地址:http://www.woxit.cn/viewthread.php?tid=3640
Product: SQL Server
Event ID: 3269
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Cannot restore the file '%ls' because it was originally written with sector size %d; '%ls' is now on a device with sector size %d.
Explanation
SQL Server uses nonbuffered I/O, which requires sectors to be aligned. The database was originally created on a disk with nonstandard disks with nonstandard sector sizes. To restore this database, the database files must be located on compatible disks. For example, if the database log was originally created on a disk with a sector size of 4K, the backup must be restored to a disk with a sector size of 4K.
User Action
Locate a disk with the required sector size and restore to that disk. You may need to use the WITH MOVE clause to direct RESTORE to use the desired disk.从微软的错误信息来看,根本就没有方法还原到磁盘扇区不同的磁盘上。
2.目前的SQL Server版本,不支持从小扇区到大扇区的自动升级转换。只支持从大扇区到小扇区的还原和附加,
这里还有两个注意点:
a.扇区的大小必须与8kB数据页圆整对齐
b.大扇区的大小必须可以平均划分小扇区的大小
由于备份文件最初是用一个扇区大小格式化的而且现在处于另一个扇区的设备上,因此不能使用。 SQL Server 使用不含缓冲区的 I/O,要求扇区对齐。必须从具有相同扇区大小的磁盘还原备份集,或者通过网络,后者使用含有缓冲区的I/O。或者,可以在备份数据库时,指定一个 WITH BLOCKSIZE 子句。
转载请注明本帖出自中联IT社区 http://www.woxit.cn/,本贴地址:http://www.woxit.cn/viewthread.php?tid=3640