Backup Fail error 317?!

  • Hello Everybody

    I have a backup problem in a database, this database have more than 50GB in several primary and secondary files, usually I get and compress a backup for 5 GB, but recently i cant generate backups, in 46% of the bk i obtain this message:

    10 percent backed up.

    20 percent backed up.

    30 percent backed up.

    40 percent backed up.

    Msg 3202, Level 16, State 0, Server GLORIADMTP, Line 1

    Write on

    '\\peecsis246\backup$\basedatos\GLORIADMTP\3-Miercoles\3Miercoles-SuperRedFULL.bak' failed, status = 317. See the SQL Server error log for more details.

    Msg 3013, Level 16, State 1, Server GLORIADMTP, Line 1

    BACKUP DATABASE is terminating abnormally.

    when i check the sql server log obtain something like this:

    05/24/2011 10:18:05,spid55,Unknown,BackupDiskFile::RequestDurableMedia: failure on backup device '\\peecsis246\backup$\basedatos\GLORIADMTP\PERM-SuperRed.bak'. Operating system error 317(error not found).

    05/24/2011 10:18:04,backup,Unknown,BACKUP failed to complete the command exec master..xp_cmdshell 'net use \\peecsis246\backup$\basedatos\GLORIADMTP romero2513155 /USER:GRUPOGLORIA\sqlserveradmin'

    05/24/2011 10:18:04,spid55,Unknown,BackupMedium::ReportIoError: write failure on backup device '\\peecsis246\backup$\basedatos\GLORIADMTP\PERM-SuperRed.bak'. Operating system error 317(error not found).

    05/24/2011 10:18:04,spid55,Unknown,Internal I/O request 0x7EC40370: Op: Write<c/> pBuffer: 0x0B610000<c/> Size: 983040<c/> Position: 24858009088<c/> UMS: Internal: 0x0<c/> InternalHigh: 0xF0000<c/> Offset: 0xC9A71E00<c/> OffsetHigh: 0x5<c/> m_buf: 0x0B610000<c/> m_len: 983040<c/> m_actualBytes: 0<c/> m_errcode: 317<c/> BackupFile: \\peecsis246\backup$\basedatos\GLORIADMTP\PERM-SuperRed.bak

    what means? error in sector disk? (I cant find anything in Saint Google) in this moment i triyng to make file backups to identify what file have the problem... but when i find it, what can i do? dbcc checkdb() cant detect anything....

    Please Some Help!!

  • Do you have another drive you can backup to?

    Do you get the same error on the same drive / folder if you try to backup master or msdb?

  • Ninja's_RGR'us (5/25/2011)


    Do you have another drive you can backup to?

    Do you get the same error on the same drive / folder if you try to backup master or msdb?

    thanks, i just gone blind, the storage have some kind of problem than cut connection with more than 1 hour, the fact than i misjudged because all backups gone cut at 46% (stats 1), and i was spected somo disk problem... this kind of alien solution in the storage gives me headache -.-

    so... 317 means connection cut?

    thanks a lot

  • Don't know, never seen that b4. Google turned up anything usefull?

  • I have experienced this problem when the disk on which the backup is being written to is compressed.

Viewing 5 posts - 1 through 4 (of 4 total)

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