• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1665
  • Last Modified:

Is this error message "Cannot back up the log of the master database " critical? how can I resolve this?

This is the alert message that I've recieved. Very often the daily backup will complete with error as follows:

Failure Reason:
"  ERROR CODE [30:325]: Error encountered during backup. Error: [ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot back up the log of the master database. Use BACKUP DATABASE instead. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.]
Associated Events:
"  79447 [backup00/JobManager] [01/05/2010 22:20:06 ]: Backup job [19777] completed. Client [sql02], Agent Type [SQL Server], Subclient [System DBs], Backup Level [Transaction Log], Objects [2], Failed [1], Duration [03:19:55], Total Size [1.31 MB], Media or Mount Path Used [ITD011L2].
"  79446 [sql02/SQLiDA] [01/05/2010 22:19:51 ]: Error encountered during backup. Error: [ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot back up the log of the master database. Use BACKUP DATABASE instead. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.]
"  79445 [sql02/SQLiDA] [01/05/2010 22:19:49 ]: Query Result [[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot back up the log of the master database. Use BACKUP DATABASE instead. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.].
"  79415 [backup00/JobManager] [01/05/2010 19:00:11 ]: New backup request received for Client [sql02], iDataAgent [SQL Server], Instance [SQL02], Subclient [System DBs], Backup Level [Transaction Log].
Files failed to back up:
"  Backup Database[master] Failed

But sometimes it completed backup with no errors. I would like to know if the above error is critical or how can I fix it? Thank you.
0
itontap001
Asked:
itontap001
2 Solutions
 
bhanukir7Commented:
hi iton,

The possible reason why this is working at times and failing at times is due to the size of data backed up /time taken for the backup.  Try to increase the VDI timeout values from the backup agent and also verify if there are any issues with your backup device

regards
bhanu
0
 
honmapogCommented:
These errors relate to backing up transaction logs of the Master database. Because the master database is a database that is in the Simple recovery model, you cannot backup transaction logs for the master database. See also http://support.microsoft.com/kb/285288.

The solution is to change what I believe is your CommVault job so that is does not try to make a transaction log backup of the master database.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now