hi

we have a 2 node cluster everything is working fine except
for backup maintainance plan

backup fails randomly for user database with error

3041 :
BACKUP failed to complete the command BACKUP DATABASE
[DBName] TO DISK =
N'e:\Backup\Dbname\DBNAME_db_200401121800.BAK' WITH
INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Thanks

Your backup may have failed due to any number of reasons. It's unlikely,
though possible, that running the SQL instance in a cluster is one of them.

Some common reasons are:

* The backup file was being locked by another process such as the filesystem
backup or virus check,
* The backup file was corrupt,
* The backup file was used by a different media set

For the last two items, specifying with format usually would help.

Also there might be additional clue in your errorlog that may point you to
the real root cause.

--
Linchi Shea
linchi_shea (AT) NOSPAMml (DOT) com


"gubba" <anonymous (AT) discussions (DOT) microsoft.com> wrote

May be 827452 or 818877