June 28, 2007 at 2:57 am
Hi,
I am backing up one of my databases at 12:00 in the morning. Last night is gave the following error:
Cannot open backup device 'I:\MSSQL\Backups\SAM\SAM_backup_Daily.bak'. Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
June 28, 2007 at 3:10 am
Is the drive that you use to take backups a networked drive. f so did you check if that was mapped to the server while the backup command was running. This could be a problem of that.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 28, 2007 at 3:16 am
No, the drive is not a networked drive. All backups are locally.
June 28, 2007 at 3:19 am
Might be the folder that you have used in the backup database might not be there. This error occurs if the path to back is given incorrect. If this is also not the case i am not sure what other cause it would be.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 29, 2007 at 7:37 am
Could another application (possibly backup software) have 'I:\MSSQL\Backups\SAM\SAM_backup_Daily.bak' open at 12:00 am but not at 3:00 am?
Norene Malaney
June 29, 2007 at 7:44 am
I'm not sure....i asked the SA the same question and he is not aware of backup software running during this time....usually when a drive is backed up, the backup job would fail if the backup job is scheduled to run at the same time the drive is being backed up.
I just recently found out that the SQL Service was stopped and started, but that should'nt be the reason since the stop/start happened between 21:00 and 22:00.
IC
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply