How to fix 'The transaction log for the database is null due to OLDEST_PAGE'
By FoxLearn 2/16/2024 4:36:25 AM 344
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 fix 'The specified sa password does not meet strong password requirements'
- How to Set Up Dark Theme in SQL Server Management Studio
- DBCC CHECKIDENT RESEED 0
- How to drop temporary table if exists
- How to convert timestamp to date in SQL Server
- How to convert SQL Server's timestamp column to datetime format
- How to convert varchar to uniqueidentifier in SQL Server
- How to Read Excel file and Import data from Excel to SQL Server in C#