March 5, 2004 at 5:26 am
What could be the exact reason for this error it comes daily. DB size is around 80 GB and I did not find any process on the server explicitly locking this AWDB_dump file.
Error:
Msg 3201, Level 16, State 1, Server YADATA, Line 1
Cannot open backup device AWDB_dump. Device error or device off-line.
BACKUP DATABASE is terminating abnormally.
--sntiwary
March 5, 2004 at 6:10 am
You are probably attempting to backup the database to a dump device when this error occurs. Look in enterprise manager under Management-->Backup you will see a list of devices, this is probably one of those, chage the path of the relevant device to reflect the correct backup location on your sever.
March 8, 2004 at 9:51 am
Be sure your tape process or something else doesn't have the file open. You can use filemon (http://www.sysinternals.com/ntw2k/source/filemon.shtml) to see who has a file handle open.
March 8, 2004 at 10:17 am
I would also check to see if your backup dump file is on a network share, that can also cause problems if the network becomes unavailable or if the server sql is on becomes too busy to service network request it can appear to SQL that the network or file is unavailable for an instant breaking your backup.
Wes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply