Troubleshooting Guide: Error 4212 — Cannot Back Up the Log of the Master Database

Why This Error Happens

The master database operates exclusively in the SIMPLE recovery model, which SQL Server enforces at all times regardless of administrative overrides. Because the SIMPLE recovery model automatically truncates the transaction log after every checkpoint, there is no persistent log chain available for a BACKUP LOG operation to capture. This is a hard architectural restriction in SQL Server 2025, not a permissions or corruption issue, so the fix lies in adjusting the backup strategy rather than the database configuration.

Step-by-Step Resolution Guide

Step 1: Confirm the Recovery Model of the Master Database

• Open SQL Server Management Studio (SSMS) or Azure Data Studio connected to your instance.
• Run the following query to verify:

  SELECT name, recovery_model_desc FROM sys.databases WHERE name = 'master';

• Confirm the result returns SIMPLE. This is expected and cannot be changed.

Step 2: Replace the Log Backup Command with a Full Database Backup

• Locate the maintenance plan, SQL Agent job, or script that is issuing the BACKUP LOG master command.
• Replace it with a full backup command instead:

  BACKUP DATABASE master 
  TO DISK = 'C:\SQLBackups\master_full.bak' 
  WITH INIT, STATS = 10;

• Ensure the target path (e.g., C:\SQLBackups\) exists and the SQL Server service account has write permissions to it.

Step 3: Update SQL Server Agent Jobs or Maintenance Plans

• Open SQL Server Agent > Jobs in SSMS.
• Edit any job step referencing BACKUP LOG master and remove it, or disable that specific step.
• If using a Maintenance Plan Wizard, uncheck “Transaction Log” backups for the master database in the backup task configuration — only “Full” should be selected for system databases.

Step 4: Schedule Regular Full Backups for System Databases

• Since master, model, and msdb cannot use log backups, schedule frequent full backups (e.g., daily) to minimize data loss exposure.
• Example SQL Agent schedule: Daily at 2:00 AM, BACKUP DATABASE master TO DISK = 'C:\SQLBackups\master_$(ESCAPE_SQUOTE(JOBID)).bak'.

Alternative or Verification Steps

• Verify the fix by manually executing the BACKUP DATABASE master command in SSMS and confirming it completes with “100 percent processed” and no error 4212 is thrown.
• If automated jobs still fail, check the SQL Server Agent job history (right-click job > View History) to confirm the log backup step was successfully removed or disabled.