Why can't I backup the transaction log ?

I'm trying to backup the transaction log of the master database but keep getting error :-

Server: Msg 4212, Level 16, State 1, Line 1
Cannot back up the log of the master database. Use BACKUP DATABASE instead.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

I can backup the database without error.

Any suggestions ?
gngAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nigelrivettConnect With a Mentor Commented:
You cannot backup the transaction log in master as it requires non-logged operations.
That's one reason why it's not a good idea to put any user objects their.
0
 
allian11Commented:
I don't know why you are trying to backup Tr. Log on Master database. Most of time , daily Full backup for master database should be enough. Truncate Log on checkpoint is enabled on master database by default. That's why you cannot backup transaction log. You have to disable it if you want to do transaction log backup.

Good Luck,
0
 
acampomaCommented:
also, by default, the master database is in simple mode
which does not suport transaction log backups
0
 
acampomaCommented:
Oops:

also, by default, the master database is in simple recovery mode
which does not suport transaction log backups
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.