System Database Transaction Log backups

[GJP55]

I have a Transaction Log Backup Scheduled Job that runs after office hours. This is always unable to backup the Transaction logs for the Master and Model Databases. Msdb is ok.

The log message doesn't give me any clues why, any idea's what could make this fail ?

 

[nigelrivett]

Master is always in simple recovery mode so you cannot back up the tr log (one reason for not putting any user objects in it).

Model is used to create new databases so should not have any transactions in it.
I would recommend setting this to simple recovery so that any databases created have that as a default.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[GJP55]

Thanks for the advice. Has do the trick.
Cheers