Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-10 : 09:27:58
|
| Alessandro writes "Error during the restore from tape!The backup is performed on a server (Master_server) nt4 sp6a with SQL Server 2000 standard. The database is 21 GB with 15 filegroups in different scsi disk.The restore is aviable only on the master_server and another windows 2000 server with SQL Server 2000 standard, but failedon ather two server Windows 2000 (server edition) with SQL Server 2000 standard. Bat the configuration is the same! (collection , service pack2, db_option etc)The error that appair after 6% to 30% of the restore is:<<6 percent restored.Server: Msg 3203, Level 16, State 1, Line 1Read on '\\.\tape0' failed, status = 23. See the SQL Server error log for more details.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally. >>Lookin in SQL log I find this error:<<BackupMedium::ReportIoError: read failure on backup device '\\.\tape0'. Operating system error 23(error not found). >><<Internal I/O request 0x43535D08: Op: Read, pBuffer: 0x06510000, Size: 65536, Position: 1517102592, UMS: Internal: 0xC000009C, InternalHigh: 0xAA00, Offset: 0x5A6D2600, OffsetHigh: 0x0, m_buf: 0x06510000, m_len: 65536, m_actualBytes: 43520, m_errcode: 23, BackupFile: \\.\Tape0 >>The tape used for the bck is a 20-40GB tape (150 meter), and the tape is a DDS4.Thank for your help!" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-09-10 : 18:09:27
|
| Just a WAG, but could this be caused by a bad tape? |
 |
|
|
|
|
|
|
|
Read on '\\.\tape0' failed, status = 23.