August 13, 2003 at 10:26 am
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.
August 13, 2003 at 10:33 am
Have you tried backing the database up to disk, just to establish that it is the tape drive that is causing the problem?
August 13, 2003 at 11:59 am
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.
August 13, 2003 at 5:36 pm
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
August 14, 2003 at 7:52 am
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