How to fix 'The transaction log for the database is null due to OLDEST_PAGE'
By FoxLearn 2/16/2024 4:36:25 AM 293
Sometimes when you execute insert update or delete statement on a table in SQL Server you get the above error. To fix the problem you can change Recovery Model to Simple then Shrink Files Log.
- Right click 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 convert varchar to uniqueidentifier in SQL Server
- Connection string mysql
- How to convert string to datetime in SQL
- How to Download and Restore Northwind database to SQL Server
- Download backup of Northwind database for SQL Server
- Download AdventureWorks sample database for SQL Server
- Download SQL Server Management Studio (SSMS) Versions
- How to Download SQL Server Management Studio (SSMS) Versions