Master transaction log

Quick question - why is it not possible to backup the master database's tran
saction log?
TIA,
John BrownJohn Brown wrote:
> Quick question - why is it not possible to backup the master
> database's transaction log? TIA,
> John Brown
See:
PRB: Transaction Log Backups of Master Database Are Not Allowed
http://support.microsoft.com/defaul...&NoWebContent=1
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Sebastian, this is helpful, but what I wondered is is there any logic
al reason why a master transaction log backup is not possible?
Regards,
John|||John Brown wrote:

> Thanks Sebastian, this is helpful, but what I wondered is is there
> any logical reason why a master transaction log backup is not
> possible? Regards,
Yes, it is. Master database is setup in the SIMPLE recovery mode, when
transaction log is truncated on checkpoints and its space occupied by
commited transactions is constantly reused. That is why SIMPLE recovery
model does not allow transaction logs backups. It is a small database with
only a few transactions from time to time, SIMPLE recovery model is optimal
for this system database.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.