FIX: SSRS logs fill up the hard disk and agent jobs are not recreated after database migration in SQL Server 2016

Symptoms

After you migrate a report server database, for example, from one database server to another in SQL Server 2016, you experience one of the following issues:
  • The SQL Server Agent jobs that are associated with the Reporting Services subscriptions cannot be re-created.
  • The Reporting Services report server trace logs fill up the free space on the hard disk.


Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.
Properties

Article ID: 3167434 - Last Review: Jul 25, 2016 - Revision: 1

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core

Feedback