My Backup keeps failing. I am using 1

[iriestar]

My Backup keeps failing. I am using Veritas 7.3 SBS on NT SBS 4.5

I have included the log.

======================================================================
Job server: Name
Job name: Backup 0024
Job started: Tuesday, August 12, 2003 at 11:45:14 AM
Job type: Backup
Log file: BEX06.txt
======================================================================

No appendable media could be mounted.
Switching to overwrite operation on scratch media.

Drive and media information from media mount:
Drive Name: SONY 0
Media Cartridge Label: 4M000001
Targeted Media Set Name: Backup 0020

======================================================================
Job Operation - Backup
Media operation - overwrite.
Hardware compression enabled.
======================================================================
Unable to attach to \\Name\Microsoft Exchange Mailboxes.
Access is denied.

^ ^ ^ ^ ^
Unable to attach to \\Name\Microsoft Exchange Mailboxes.
^ ^ ^ ^ ^

Media Name: "Media created 08/12/03 11:45:14 AM"
Backup of "E: "
Backup set #1 on storage media #1
Backup set description: "Backup 0024"
Backup Type: NORMAL - Back Up Files - Reset Archive Bit
Backup started on 8/12/03 at 11:45:54 AM.

Backup completed on 8/12/03 at 12:06:02 PM.
Backed up 6003 files in 546 directories.
Processed 2,367,378,755 bytes in 20 minutes and 8 seconds.
Throughput rate: 112.1 MB/min
----------------------------------------------------------------------

Media Name: "Media created 08/12/03 11:45:14 AM"
Backup of "Name "
Backup set #2 on storage media #1
Backup set description: "Backup 0024"
Backup Type: DATABASE - Back Up Entire Database
Backup started on 8/12/03 at 12:06:05 PM.

An error occurred on a query to filegroup master..PRIMARY.
^ ^ ^ ^ ^
SQL Server returned the following error message:

You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database.

^ ^ ^ ^ ^
Unable to open the item master?PRIMARY - skipped.

An error occurred on a query to filegroup msdb..PRIMARY.
^ ^ ^ ^ ^
SQL Server returned the following error message:

BACKUP LOG is not allowed while the trunc. log on chkpt. option is enabled. Use BACKUP DATABASE or disable the option using sp_dboption.

^ ^ ^ ^ ^
Unable to open the item msdb?PRIMARY - skipped.

An error occurred on a query to filegroup Northwind..PRIMARY.
^ ^ ^ ^ ^
SQL Server returned the following error message:

BACKUP LOG is not allowed while the trunc. log on chkpt. option is enabled. Use BACKUP DATABASE or disable the option using sp_dboption.

^ ^ ^ ^ ^
Unable to open the item Northwind?PRIMARY - skipped.

An error occurred on a query to filegroup pubs..PRIMARY.
^ ^ ^ ^ ^
SQL Server returned the following error message:

BACKUP LOG is not allowed while the trunc. log on chkpt. option is enabled. Use BACKUP DATABASE or disable the option using sp_dboption.

^ ^ ^ ^ ^
Unable to open the item pubs?PRIMARY - skipped.

Backup completed on 8/12/03 at 12:10:46 PM.
Backed up 5 database(s)
Backed up 1 filegroup(s) in 5 database(s)
4 items were skipped.
Processed 22,078,921 bytes in 4 minutes and 41 seconds.
Throughput rate: 4.5 MB/min
----------------------------------------------------------------------

======================================================================
Job Operation - Verify
======================================================================

Verify of "E: "
Backup set #1 on storage media #1
Backup set description: "Backup 0024"
Verify started on 8/12/03 at 12:11:16 PM.

Verify completed on 8/12/03 at 12:29:42 PM.
Verified 6003 files in 546 directories.
0 files were different.
Processed 2,367,378,755 bytes in 18 minutes and 26 seconds.
Throughput rate: 122.5 MB/min
----------------------------------------------------------------------

Verify of "Name "
Backup set #2 on storage media #1
Backup set description: "Backup 0024"
Verify started on 8/12/03 at 12:29:42 PM.

Verify completed on 8/12/03 at 12:29:49 PM.
Verified 5 database(s)
Processed 22,078,921 bytes in 7 seconds.
Throughput rate: 180.5 MB/min
----------------------------------------------------------------------

======================================================================
Job ended: Tuesday, August 12, 2003 at 12:29:50 PM
Job completion status: Failed
======================================================================

 

[NortonES2]

Don't know about SBS editions but I see you are trying to backup Exchange and SQLServer, I assume you have purchased the agent software for these applications.

-------------------------------

If it doesn't leak oil it must be empty!!

 

[FunTechie]

Is there a system account associated with backing-up SQL and Exchange ??? If so, has this account and/or password changed ??

Ed
"FunTechie"

 

[seong76]

close BE, stop all BE related services. rename BEWINUI.UNI TO BEWINUI.OLD. Restart BE services and BE and try backing up.

 

[SQLBill]

The problem with SQL Server is that the databases are set for SIMPLE recovery mode. You CANNOT do a log backup when the database is set for SIMPLE. MASTER and MSDB cannot be set for FULL.

You didn't say which version of SQL Server you are using, so hopefully this helps...

Open Enterprise Manager, expand down to the databases, right click on your database and select Properties. Go to the Options tab. Look at what RECOVERY MODE: is set as. Change it to FULL.

-SQLBill