Is the master database backup crucial for restoring MS SQL server in the event where you have to res
- by Imagineer
I have been advise by Commvault partner support to turn off the backup of the master database as the backup failed due to the log file being lock.
The following is the advise given:
"The message is caused by Commvault’s inability to backup the master database’s transaction log.
If this is happening intermittently its possible that something is locking the transaction log, preventing SQL iData agent from accessing the log.
Typically the master database is just a template and is not used by any applications (applications that do require the use of an SQL database create their own) so there should be no harm in preventing it from being backed up
You can do this by nominating NOT to back it up in the primary copy for the SQL data agent"
The following is the error that I get.
sqlxx SQL Server/
SQLxx N/A/
System DBs 19856*
(CWE) Transaction Log N/A 01/08/2010 19:00:16
(01/08/2010 19:00:18 ) 01/08/2010 19:03:15
(01/08/2010 19:03:14 ) 1.44 MB 0:01:11 0.071 2 0 1
ITD014L2
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.]
Job Options:Create new index, Start new media, Backup all subclients, Truncation Log, Follow mount points , Backup files protected by system file protection , Stop DHCP service when backing up system state data, Stop WINS service when backing up system state data
Associated Events:
• 79714 [backupxx/JobManager] [01/08/2010 19:03:15 ]: Backup job [19856] completed. Client [sqlxx], Agent Type [SQL Server], Subclient [System DBs], Backup Level [Transaction Log], Objects [2], Failed [1], Duration [00:02:59], Total Size [1.44 MB], Media or Mount Path Used [ITD014L2].
• 79712 [sqlxx/SQLiDA] [01/08/2010 19:01:53 ]: 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.]
• 79711 [sqlxx/SQLiDA] [01/08/2010 19:01:51 ]: 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.].
• 79707 [backupxx/JobManager] [01/08/2010 19:00:15 ]: New backup request received for Client [sqlxx], iDataAgent [SQL Server], Instance [SQLxx], Subclient [System DBs], Backup Level [Transaction Log].
Files failed to back up:
• Backup Database[master] Failed
Please advise, thank you.
