Sometimes you may face error “The transaction log for database is full due to ‘LOG_BACKUP’” this error due to your database has been set-up as full recovery model and transaction log becomes full due to LOG_BACKUP. and due to this, you will not be able to perform any transaction on this database. To resolve the issue, take a transaction log backup and set the database in simple recovery model. To do so you need to do the following #1 Change the database model to SIMPLE Recovery ALTER DATABASE Database_name SET RECOVERY SIMPLE GO #2 Truncate log file DBCC SHRINKFILE (Database_name, 1); GO 3# Reset model to FULL Recovery ALTER DATABASE Database_name SET RECOVERY FULL GO

Increment the number in array if number at index is 9 increment the preceding index

SShakir

I got an array [3,4,8,9] I want to increment the last index by 1 and if that index is 9 I want to increment the preceding index in a way that full number becomes [3,4,9,0].

You can provide a solution in java or javascript. I tried coding this problem and I have failed. Any help will be greatly appreciated.