--- title: BACKUP LOG was unable to log updates for database in SQL Server 2016 description: In this post, Ryan Allport explains why if you’re running SQL Server 2016, you may want to install SQL Server Service Pack 1, CU8 - or risk issues with backup logs. image: https://blog.coeo.com/hubfs/DBA%20Blog%20Images/BACKUP%20LOG%20was%20unable%20to%20log%20updates%20for%20database-1.png --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://blog.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # BACKUP LOG was unable to log updates for database in SQL Server 2016 # The Coeo Blog ![Ryan Allport](https://blog.coeo.com/hubfs/Profile%20photos/RyanCircle.jpg) If you’re running SQL Server 2016, you may want to install SQL Server Service Pack 1, CU8. I came across an issue recently that effectively caused the transaction log backups to hang. Through our proactive monitoring, we were alerted to the fact that a log backup had not been taken in 4 hours. Upon investigation, I could see the log backup had failed. This occurred when the backup operation was kicked off via an SQL Agent job, or manually executed within a query window. The backup wasn’t failing but SQL Server wasn’t actively performing the operation; it had *hung*. I couldn’t see that disk I/O was increasing when querying the SPID number, plus, when running my script that gathers percentage completed, this wasn’t moving; it remained at 0% for the duration of the active session.  As I couldn’t see any reason for this, I checked the SQL Server error log, this revealed the below error: “BACKUP LOG was unable to log updates for database ‘DatabaseName’. Subsequent log backups will be required to advance the backup point from () to () after log space is made available for logging them.” In the wild, it would look something like:  ![BACKUP LOG was unable to log updates for database-1](https://blog.coeo.com/hs-fs/hubfs/DBA%20Blog%20Images/BACKUP%20LOG%20was%20unable%20to%20log%20updates%20for%20database-1.png?width=381&name=BACKUP%20LOG%20was%20unable%20to%20log%20updates%20for%20database-1.png)   To me, the error message makes very little sense (grammatically and informationally), but what stood out to me was the ‘after log space is made available for logging them.’ snippet. The strange thing here is that the log file had plenty of free space available internally and the disk had quite a bit of free space available for the log to auto-grow. Researching this, it became apparent that this is a known issue and Microsoft have released a fix within SQL Server 2016 Service Pack 1, CU8. As far as I know, this only affects instances running on SQL Server 2016, but from a few Microsoft articles, they imply it’s also been noted in 2014 and more recently, 2017. **Work Around** I did figure out a temporary work around by growing the affected database transaction log manually by just a few kilobytes. After doing this, the transaction log backup job completed successfully. The problem with this is that it could reoccur again at any moment, therefore I would strongly recommend patching your instance as soon as possible. It can be caught reasonably early if you’re monitoring for log backups not being taken in X hours or if a log file is reaching near capacity. **Update** As users of SQL Server were still see this error after applying CU8, on the 30th of May, Microsoft have released Cumulative Update 1 for SQL Server 2016 SP2 which includes a *fix* for this issue. [The update can be found here](https://support.microsoft.com/en-us/help/4087406/error-9002-when-you-run-non-file-growth-operations-in-sql-server-2014). ### Subscribe to Email Updates ## Related posts --- ### [Troubleshooting Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/troubleshooting-ola-hallengrens-maintenance-solution) ### [Domain-Independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group](https://blog.coeo.com/domain-independent-windows-failover-cluster-for-sql-server-alwayson-availability-group) ### [Microsoft Envision UK 2022](https://blog.coeo.com/microsoft-envision-uk-2022) ### [SQLBits 2022 session - Field Testing Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/sqlbits-2022-session-field-testing-ola-hallengrens-maintenance-solution) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | info@coeo.com ## Contact Us By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested. You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**. ## Upcoming Events [See all events](https://www.coeo.com/events/) #### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB [![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) - [Solutions](https://www.coeo.com/solutions/) - [Next Steps](https://www.coeo.com/next-steps/) - [Dedicated Support](https://www.coeo.com/dedicated-support/) - [Case studies](https://www.coeo.com/case-studies/) - [Technologies](https://www.coeo.com/solutions/technologies/) - [Industries](https://www.coeo.com/industries/) - [Finance](https://www.coeo.com/industries/finance/) - [Retail](https://www.coeo.com/industries/retail/) - [Technology](https://www.coeo.com/industries/technology/) - [The Team](https://www.coeo.com/people/) - [Join Us](https://www.coeo.com/careers/) - [Graduate Programme](https://www.coeo.com/graduate-programme/) - [About Coeo](https://www.coeo.com/about-coeo/) - [The Coeo Blog](https://www.coeo.com/blog/) - [Contact us](https://www.coeo.com/contact-us/) - [Privacy Notice](https://www.coeo.com/privacy/) - [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy) - [Events](https://www.coeo.com/events) Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png) Back to top