SQL Server backup issue
we running sql server 2008 r2 sp1. there scheduled transaction log backup using sql server maintenance job runs @ time of day. job runs fine on few days , fails few days , there no specific pattern. changed schedule run every 5 minutes , log backups fine first 3 attempts , started failing randomly.
-- operating system error 53(the network path not found.) --
i not sure why fails few times , runs fine rest of times. backups going directly san storage , use unc path - e.g. \\vnvx\sql_backups\
sql server errorlog has following messages:
backup error: 3041, severity: 16, state: 1.
error: 18204, severity: 16, state: 1.
backupdiskfile::createmedia: backup device
'n:\backups\userdatabases\database\db _backup_200911111511.bak' failed
create. operating system error 53(the network path not found.)
if fails on regular basis have checked permissions, sql server agent start id etc. fails few times , runs few times. job set run 1 retry after 2 minutes , 2nd attempt goes through.
please help. in advance.
hi,
it doesn't sound sql server related. i'd guess problem dns resolution, network interruptions, etc.
have created backup device \\vnvx\sql_backups? what if try backing directly unc path?
what backing locally, robocopying (or something) san share?
<br/> thanks, andrew <br/>
SQL Server > SQL Server Database Engine
Comments
Post a Comment