How to fix 'The transaction log for the database is null due to OLDEST_PAGE'
By FoxLearn 1/22/2025 8:20:19 AM 563
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
- How to Query JSON in SQL Server
- How to modify JSON in SQL Server
- How to set time to 00:00:00 with GETDATE() in SQL
- How to find all the dependencies of a table in SQL Server
- How to Find Objects Referencing a Table in SQL Server
- Case sensitivity in SQL Server
- How to Convert varchar to uniqueidentifier in SQL Server
- How to use GROUP BY in SQL