July 25, 2002 at 11:56 am
I am getting this error when trying to backup up a database to TAPE.
Error:
Executed as user: SECSOURCE\admin_. Operation on device 'tape in db1' exceeded retry count.
[SQLSTATE 42000] (Error 3230) BACKUP DATABASE is terminating abnormally.
[SQLSTATE 42000] (Error 3013). The step failed.
Is this sql's way of telling me that the tape is full? If so how can I get my jobs to over write data, if the tape is full? Any ideas would be great.
thanks.
July 25, 2002 at 4:45 pm
I think you have to decide before you start the backup whether to append or format/init. You could trap the error and then format if you determined it was full - though not sure that is the cause of your problem. More likely a bad tape or drive.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply