I'm getting the following on a particular client...

 

 

02/15/2006 15:00:07 Backup of msdb failed.

02/15/2006 15:00:07 ACO5422E Received the following from the MS SQL
server:

02/15/2006 15:00:07 [Microsoft][ODBC SQL Server Driver][SQL Server]The
statement BACKUP LOG is not allowed while the recovery model is SIMPLE.
Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.

02/15/2006 15:00:07 [Microsoft][ODBC SQL Server Driver][SQL
Server]BACKUP LOG is terminating abnormally. Microsoft SQL-DMO (ODBC
SQLState: 42000) (HRESULT:0x80041070)

 

02/15/2006 15:00:04 Backup of master failed.

02/15/2006 15:00:04 ACO5422E Received the following from the MS SQL
server:

02/15/2006 15:00:04 [Microsoft][ODBC SQL Server Driver][SQL
Server]Cannot back up the log of the master database. Use BACKUP
DATABASE instead.

02/15/2006 15:00:04 [Microsoft][ODBC SQL Server Driver][SQL
Server]BACKUP LOG is terminating abnormally. Microsoft SQL-DMO (ODBC
SQLState: 42000) (HRESULT:0x80041074)

 

Should I change the db recovery mode in SQL Enterprise Mgr to full? I am
not a SQL admin by any stretch, but we finally have those skill sets
in-house. They are asking to run transaction log backups bi-hourly or
hourly on some clients. In this particular case, the above errors occur.


 

Thanks all!

 

God bless you!!! 

Chip Bell 
Network Engineer I
IBM Tivoli Certified Deployment Professional (ITSM 5.2)
Baptist Health System 
Birmingham, AL 
Office (205) 715-5106 
Pager (205) 817-0357 
Home (256) 739-0947 

 




-----------------------------------------
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.