December 6, 2001 at 1:44 pm
I am backing up databases to a network directory, but recently my backups have sporadically started failing. The error that I am getting says"Can't open dump device '\\T01a2f1\csdba\mssql\T01CISRH1\msdbLogBackup.DAT', device error or device off line. Please consult the SQL Server error log for more details. (Message 3201).
If I run the same backup sometimes later manually it will succeed.
Can anybody help.
December 6, 2001 at 3:23 pm
That error is usually associated with an invalid or an inaccessible path. Is it possible that some other backup application has the drive space access limited during these times? Just a shot in the dark.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 10, 2001 at 9:48 am
Thanks for your response. We are looking at this aspect also. This could very well be the reason. At this point we are looking at problem with the network directory where we are trying to backup. This problem started occuring recently we were backing up the with the same schedule for some time.
December 10, 2001 at 9:54 am
This is almost always the share being inaccessable (networking problem) or rights (security problem).
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply