Backups what a pain on the NECK

  • Hey SQL gurus, I have about 4 boxes, but one is putting me as a good candidate to be fired.

    This box is runnig win3k and SQL 2000 srvpack3 like the others, and running List Manager from Lyris.

    My backup is reporting a failure.

     

    BackupMedium::ReportIoError: write failure on backup device 'E:ListServer.bak'. Operating system error 2(The system cannot find the file specified.).

    Internal I/O request 0x047B1318: Op: Write, pBuffer: 0x065F0000, Size: 983040, Position: 6864050688, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x99211A00, OffsetHigh: 0x1, m_buf: 0x065F0000, m_len: 983040, m_actualBytes: 0, m_errcode: 2, BackupFile: E:ListServer.bak 

     

    I tried putting a old backup file, so there is a file there.  also i run the backpup as "SA" and also administrator and no luck.

    Please help.

    Thanks in advance

  • Hi,

    From what I understand is that you are trying to append to a existing backup file.

    Looks like the existing backup file is corrupted.

    Tried trying create a new backup file OR Try creating the backup to a different location. And is it a full backup or a differential or a T-log backup file ?

    Please give more information to assist you accordingly.

    --Kishore

  • Have you ever backed up to E before?

    Is it a local drive or a network drive?

    Is it a CD drive?

    SQL Server doesn't like backing up to network drives.

    -SQLBill

  • could it be something as simple as the path missing a slash?

    'E:ListServer.bak' might really need to be 'E:\ListServer.bak'

     

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Thanks to all of you for replying, it is not a network drive nor CD drive and it has the  slash after the E:.

    I try recreating the file, backing up to a different local drive or another path, and nothing.

    The wierd thing is that it goes for about 30 min, and then dies.

    I do not what else to do.

     

  • Check for an antivirus software or archiving software that may be grabbing hold of the file.  I've had this problem before and pinpointed the problem to AV software.

  • I do have intivirus software in this machine.

    I'll disabled it and try again.

    Thanks,

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply