[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

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 ?
0
gng
Asked:
gng
  • 2
1 Solution
 
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
 
nigelrivettCommented:
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
 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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