May 25, 2011 at 10:38 am
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!!
May 25, 2011 at 10:44 am
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?
May 25, 2011 at 3:50 pm
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
May 25, 2011 at 3:55 pm
Don't know, never seen that b4. Google turned up anything usefull?
January 2, 2012 at 10:07 pm
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