BACKUP to tape failed

  • Hi,

    Recently, one of our SQL Server 2000 database backup failed and log says :

    BACKUP failed to complete the command BACKUP DATABASE [InSightOPMS] FILEGROUP='PRIMARY' TO virtual_device = 'BackupExecSqlAgent_PRIMARY_00'"

    We simply backup this database to a tape because it's not a big one.

    We have eliminated the software issue and also changed many tapes but helpless.

    This database's recovery mode set to "Simple", and others set to "Full".

    Does anyone has any idea what could cause the problem?

    Thanks in advance.

  • Have you tried backing the database up to disk, just to establish that it is the tape drive that is causing the problem?

  • Yes we tried to back up to another disk drive and worked yesterday.

    Today, we tried to change the recovery mode from Simple to Full and backup worked fine. When we switched back to Simple mode, it failed again..

    Does the recovery mode cause the tape backup problem?

    Thanks.

  • What kind of a backup are you trying when you are in SIMPLE recovery mode? When you are in SIMPLE recovery mode, you can only do complete or differential backups. Filegroup backups are not support in Simple recovery mode.

    HTH

    Billy

  • I had the same problem a few months ago. Backup Exec will only work if you set the recovery model to full.

    Jenn

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply