How to fix 'The transaction log for the database is null due to OLDEST_PAGE'

The error can occur when executing insert, update, or delete statements in SQL Server.

To resolve it, change the database's recovery model to Simple and then shrink the transaction log file.

You can use the SQL Management Studio to shrink the transaction log file by right-clicking on your database, then select Properties => Options => Recovery Model => Simple

Right click on your database, then select Database Tasks => Shrink => Files => Log

Next, You can check your db log file size at Database Properties => Files => Database Files => Path

If you want to check full sql server log, you can open Log File Viewer at SSMS => Database => Management => SQL Server Logs => Current

And don't forget to check your disk make sure it not full