Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHi Guys, I am facing a problem with sql server 2000 sp3 backup to network.This backuP is as part of scheduled backup to another server in the same network and was working fine for the last 3 yrs But Recently the backUP is failing with following errors BackupMedium::Report IoError: write failure on backup device '\\192.168.30. 231\dbbackups\rptser ver\Revenues_db_2006 02280100.BAK'. Operating system error 121(The semaphore timeout period has expired.). Internal I/O request 0x3CF14628: Op: Write, pBuffer: 0x08260000, Size: 983040, Position: 12786176, UMS: Internal: 0x0, InternalHigh: 0xF0000, Offset: 0xC31A00, OffsetHigh: 0x0, m_buf: 0x08260000, m_len: 983040, m_actualBytes: 0, m_errcode: 121, BackupFile: \\192.168.30. 231\dbbackups\rptser ver\Revenues_db_2006 02280100.BAK I have formateed the destination drive to where backup is taking place but still same error. the backup file size is 8.5 GB. Pls Aedvice.
Post Follow-up to this messageNot to alarm you but I found something out on the web about this strange error... http://www.thescripts.com/forum/thread78842.html might worth the look... "bijupg@hotmail.com" < bijupghotmailcom@dis cussions.microsoft.com> a écrit dans le message de news: 281CE432-4B50-44CE-A299- 19653E1AEF37@microso ft.com... > Hi Guys, > I am facing a problem with sql server 2000 sp3 backup to network.This > backuP > is as part of scheduled backup to another server in the same network and > was > working fine for the last 3 yrs But Recently the backUP is failing with > following errors > > BackupMedium::Report IoError: write failure on backup device > '\\192.168.30. 231\dbbackups\rptser ver\Revenues_db_2006 02280100.BAK'. > Operating system error 121(The semaphore timeout period has expired.). > > Internal I/O request 0x3CF14628: Op: Write, pBuffer: 0x08260000, Size: > 983040, Position: 12786176, UMS: Internal: 0x0, InternalHigh: 0xF0000, > Offset: 0xC31A00, OffsetHigh: 0x0, m_buf: 0x08260000, m_len: 983040, > m_actualBytes: 0, m_errcode: 121, BackupFile: > \\192.168.30. 231\dbbackups\rptser ver\Revenues_db_2006 02280100.BAK > > I have formateed the destination drive to where backup is taking place but > still same error. > the backup file size is 8.5 GB. > Pls Aedvice.
Post Follow-up to this messagemy daily backup failed one night after I applied one of monthly patches from MS. Removing the patch fixed the problem. I called MS. At first they asked me to update the drivers but I did everything before I called them. Then they blamed the hardware but I threw back I was using a Compaq server with compatible h/w to run the system per MS. Later they showed me to generate a server dump and sent it to MS. After more than a week with lot of calls, and 3 dumps sent to MS, they said it was a bug but won't fix it since it just happen to this server with this controller. p.s. my server is Compaq DL380, windows 2000, sql 2000 sp4. "bijupg@hotmail.com" < bijupghotmailcom@dis cussions.microsoft.com> wrote in message news:281CE432-4B50-44CE-A299- 19653E1AEF37@microso ft.com... > Hi Guys, > I am facing a problem with sql server 2000 sp3 backup to network.This > backuP > is as part of scheduled backup to another server in the same network and > was > working fine for the last 3 yrs But Recently the backUP is failing with > following errors > > BackupMedium::Report IoError: write failure on backup device > '\\192.168.30. 231\dbbackups\rptser ver\Revenues_db_2006 02280100.BAK'. > Operating system error 121(The semaphore timeout period has expired.). > > Internal I/O request 0x3CF14628: Op: Write, pBuffer: 0x08260000, Size: > 983040, Position: 12786176, UMS: Internal: 0x0, InternalHigh: 0xF0000, > Offset: 0xC31A00, OffsetHigh: 0x0, m_buf: 0x08260000, m_len: 983040, > m_actualBytes: 0, m_errcode: 121, BackupFile: > \\192.168.30. 231\dbbackups\rptser ver\Revenues_db_2006 02280100.BAK > > I have formateed the destination drive to where backup is taking place but > still same error. > the backup file size is 8.5 GB. > Pls Aedvice.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread