Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup Exec 8.6 Log Backup Problem(s)

Status
Not open for further replies.

Gigadafud

IS-IT--Management
Sep 24, 2003
3
US
backup exec 8.6
when my sql log backup runs at night, it truncates. but i am getting the following errors:

An error occurred on a query to database msbd.
^^^^^
The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. User BACKUP DATABASE or change the recovery model using the ALTER DATABASE.
^^^^^
Unable to open the item msdb - skipped.

At first, i thought no big deal, the database was accidently set to simple instead of full. so i switched it back to full and did not think twice about it. came back in the next day and got the same exact problem. so its almost like backup exec is messing with my recovery model setting and changing it. i do not understand whats going on.

the second error is:
An error occurred on a query to database master.
^^^^^
Cannot back up the log of the master database. Use BACKUP DATABASE instead.
^^^^^
Unable to open the item master - skipped.

this one almost sounds like a permissions issue, but i know that cannot be the case. i know that BE has access. so i am confused today. anyone that has any suggestions would be greatly appreciated. thanks in advance!!
 
Master database is ALWAYS SIMPLE. You can only do a full backup (BACKUP DATABASE) of the Master database. That's from the Microsoft SQL Server Books OnLine.

As for MSDB, I don't know why it's changing from FULL to SIMPLE. I've heard of others having that problem, but I haven't seen an answer to it.

I don't use BE to backup my SQL Server databases. I use the 'native' SQL Server BACKUP DATABASE and BACKUP LOG commands to backup to hard drive. Then I use BE to copy those .bak files to tape.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top