Cannot use backup file %s. Originally formatted sector size 512 and now device sector size

Customer is trying to restore a backup of their database. SQL Server gives
the error:
Cannot use backup file %s.
Originally formatted sector size 512 and now device sector size 2048.
Only one guy (in Germany in March 2000) has ever seen this error. And he
never got a resolution.
(already posted in m.p.s.msde group)Figured it out. He was trying to restore the backup from off a CD. Copy the
file to the local hard drive, and it worked.
i've also seen that if you try restoring the backup across a network, it can
also fix it.
References:
Error: 3268
Severity: 16
Description: 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.
http://ddbcinc.com/askDDBC/topic.asp?TOPIC_ID=272
Posted - 05/04/2004 : 10:36:06
----
I backed up a SQL Database from a SQL Standard Editon. Now I am trying to
restore to a Desktop Edition.
While Restoring, I get the below error:
[SQL Server] szSqlState = 37000,fNativeError = 3268, errMsg =[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use the backup file
'DBASQL_DB_testdb_PID3732TID3216BID0TS96cac8VD0' because it was originally
formatted with sector size 512)
Any ideas
Thanks
Santhosh
From Books On Line:
"SQL Server uses nonbuffered I/O, which requires sectors to be aligned. 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 when you back up the database."
If you can take a new backup of the existing database, use the WITH
BLOCKSIZE clause, specifying the block size of the Desktop Edition machine's
device. If you cannot take a fresh backup, you can try restoring it over the
network, though this will obviously be significantly slower.
askDDBC
http://www.windowsitpro.com/Article/ArticleID/14364/14364.html
[December 21, 1999]
Why do I get the error "Cannot use file <logfile> because it was originally
formatted with sector size <xxx> and is now on a device with sector size
<yyy> " when I move SQL Server's log file?
InstantDoc #14364
A. This only occurs with SQL 7.x, not 6.x. For performance/consistency
reasons the log writes are aligned on physical sector boundaries. 95%+ of
disks will have the same physical sector size, but if you try and move
between different vendor raid systems, or utilise some form of NAS device
then you may see this problem.
The only work-around is to re-create the log file on the new device and
backup/restore the database.
"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:u7176xMMGHA.3052@.TK2MSFTNGP10.phx.gbl...
> Customer is trying to restore a backup of their database. SQL Server gives
> the error:
> Cannot use backup file %s.
> Originally formatted sector size 512 and now device sector size 2048.
> Only one guy (in Germany in March 2000) has ever seen this error. And he
> never got a resolution.
>

Cannot use backup file %s. Originally formatted sector size 512 and now device sector

Customer is trying to restore a backup of their database. SQL Server gives
the error:
Cannot use backup file %s.
Originally formatted sector size 512 and now device sector size 2048.
Only one guy (in Germany in March 2000) has ever seen this error. And he
never got a resolution.
(already posted in m.p.s.msde group)Figured it out. He was trying to restore the backup from off a CD. Copy the
file to the local hard drive, and it worked.
i've also seen that if you try restoring the backup across a network, it can
also fix it.
References:
Error: 3268
Severity: 16
Description: 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.
http://ddbcinc.com/askDDBC/topic.asp?TOPIC_ID=272
Posted - 05/04/2004 : 10:36:06
----
--
I backed up a SQL Database from a SQL Standard Editon. Now I am trying to
restore to a Desktop Edition.
While Restoring, I get the below error:
[SQL Server] szSqlState = 37000,fNativeError = 3268, errMsg =
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use the ba
ckup file
'DBASQL_DB_testdb_PID3732TID3216BID0TS96
cac8VD0' because it was originally
formatted with sector size 512)
Any ideas
Thanks
Santhosh
From Books On Line:
"SQL Server uses nonbuffered I/O, which requires sectors to be aligned. 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 when you back up the database."
If you can take a new backup of the existing database, use the WITH
BLOCKSIZE clause, specifying the block size of the Desktop Edition machine's
device. If you cannot take a fresh backup, you can try restoring it over the
network, though this will obviously be significantly slower.
askDDBC
http://www.windowsitpro.com/Article...4364/14364.html
[December 21, 1999]
Why do I get the error "Cannot use file <logfile> because it was originally
formatted with sector size <xxx> and is now on a device with sector size
<yyy> " when I move SQL Server's log file?
InstantDoc #14364
A. This only occurs with SQL 7.x, not 6.x. For performance/consistency
reasons the log writes are aligned on physical sector boundaries. 95%+ of
disks will have the same physical sector size, but if you try and move
between different vendor raid systems, or utilise some form of NAS device
then you may see this problem.
The only work-around is to re-create the log file on the new device and
backup/restore the database.
"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:u7176xMMGHA.3052@.TK2MSFTNGP10.phx.gbl...
> Customer is trying to restore a backup of their database. SQL Server gives
> the error:
> Cannot use backup file %s.
> Originally formatted sector size 512 and now device sector size 2048.
> Only one guy (in Germany in March 2000) has ever seen this error. And he
> never got a resolution.
>

Cannot Sync the Email from home PC with ActiveSync 4.5 and WM6

I have a WM6 phone which got an Exchange server setting for my email. When I connected the device by USB, the activesync will show "Synchronization could not completed. Try again later. Support Code 80072f7d". When I search the result from this forum. The answer is not related to mobile phone issues.

Will anyone able to help?

Thanks, ppdog

This forum is SQL CE/Mobile related. Since your question is not related to SQL CE/Mobile, it's off topic here.

If you’re having a hardware issue, please contact hardware manufacturer or reseller. If you having an issue with 3rd party software, please contact respective software manufacturer or reseller. Otherwise please post to relevant forum or news group:

http://support.microsoft.com/newsgroups/default.aspx

Closing as off topic.