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

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........