How to fix Error 7979 on Windows Server 2025 / Windows 11

by

Troubleshooting Guide: SQL Server Error 7979

Why This Error Happens

Error 7979 typically occurs during transactional replication when the replication agent encounters an inconsistency while processing replicated transaction metadata, often due to a corrupted distribution database or a mismatch between the publisher and subscriber schema versions. This can also result from interrupted log reader agent jobs, orphaned replication metadata left behind after an improper cleanup, or insufficient permissions on the distribution database for the account running the replication agents. In some cases, the issue stems from a corrupted .cache file used by the Log Reader Agent on Windows Server 2025 environments with aggressive disk cleanup policies.

Step-by-Step Resolution Guide

Step 1: Verify Replication Agent Status and Logs

  • Open SQL Server Management Studio (SSMS) and connect to the Distributor instance.
  • Navigate to Replication > Monitor and check the status of the Log Reader Agent and Distribution Agent.
  • Review the agent history for the exact failing transaction sequence number (xact_seqno) referenced alongside Error 7979.
  • Check the SQL Server error log located at C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\Log\ERRORLOG for additional context.

Step 2: Validate and Repair Distribution Database Integrity

  • Run DBCC CHECKDB (distribution) WITH NO_INFOMSGS, ALL_ERRORMSGS; to check for corruption in the distribution database.
  • If corruption is found, restore the distribution database from the last known good backup rather than attempting an in-place repair.
  • Execute sp_browsereplcmds on the publisher to confirm whether the problematic transaction can be read without errors.

Step 3: Reinitialize the Affected Subscription

  • In SSMS, right-click the problematic subscription under Local Subscriptions and select Reinitialize Subscription.
  • Alternatively, run the following T-SQL on the publisher:
  • EXEC sp_reinitsubscription @subscriber = N'SubscriberName', @destination_db = N'DestinationDB', @publication = N'PublicationName';
  • Restart the SQL Server Agent service via services.msc on both the Distributor and Subscriber servers to clear any cached job states.

Step 4: Check Permissions on Replication Agent Accounts

  • Confirm the account running the SQL Server Agent service has db_owner rights on the distribution database.
  • Validate this using EXEC sp_helprotect NULL, NULL, 'distribution';
  • Ensure the account also has Log on as a service rights in Local Security Policy (secpol.msc) on Windows Server 2025.

Alternative or Verification Steps

  • After reinitializing, monitor the Replication Monitor for at least one full synchronization cycle to confirm Error 7979 does not reoccur.
  • If the error persists, drop and recreate the publication entirely using sp_droppublication and sp_addpublication, then re-add subscribers to eliminate any residual metadata corruption.