Hi there,
I've been sent a backup file from a SQL Server 2000 DB and tried
restoring into a blank DB (with the same name) on my SQL Server 2K,
only it errors, see below:
(I've separated each line with a return, to make it more readable)
2005-07-08 11:08:23.93 spid51 BackupIoRequest::WaitForIoCompletion:
read failure on backup device 'C:\file location to backup'. Operating
system error 87(The parameter is incorrect.).
2005-07-08 11:08:23.94 spid51 Internal I/O request 0x03BDFCEC: Op:
Read, pBuffer: 0x03BDF800, Size: 512, Position: 5136, UMS: Internal:
0x103, InternalHigh: 0x0, Offset: 0x1410, OffsetHigh: 0x0, m_buf:
0x03BDF800, m_len: 512, m_actualBytes: 0, m_errcode: 87, BackupFile:
C:\file location to backup
2005-07-08 11:08:23.94 spid51 The backup data in 'C:\file location
to backup' is incorrectly formatted. Backups cannot be appended, but
existing backup sets may still be usable.
2005-07-08 11:08:23.94 spid51 Starting up database 'databizDB'.
2005-07-08 11:08:24.02 spid51 Bypassing recovery for database
'databizDB' because it is marked IN LOAD.
2005-07-08 11:08:24.16 spid51 BackupMedium::ReportIoError: read
failure on backup device 'C:\file location to backup'. Operating system
error 87(The parameter is incorrect.).
2005-07-08 11:08:24.16 spid51 Internal I/O request 0x42FC5530: Op:
Read, pBuffer: 0x03980000, Size: 512, Position: 5648, UMS: Internal:
0x103, InternalHigh: 0x0, Offset: 0x1610, OffsetHigh: 0x0, m_buf:
0x03980000, m_len: 512, m_actualBytes: 0, m_errcode: 87, BackupFile:
C:\file location to backup
It may be something simple as I've never really got that involved with
this side of it before. Hopefully someone out there can shed some light
on it, please?
This may be normal, but I had to backup the blank DB locally first
before it would let me select a file to restore, so I could change the
location.
Cheers,
Rich.