How to fix 'The transaction log for the database is null due to OLDEST_PAGE'
By FoxLearn 2/16/2024 4:36:25 AM 66
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
- SQL Server Migration Assistant
- How to Download and Restore Northwind database to SQL Server
- How to use SQL INSERT INTO SELECT Statement
- Data type SQL Server
- How to drop table if exists in sql server
- How to fix 'The specified directory for the INSTALLSHAREDDIR parameter is not valid'
- How to get all table names of a particular database using TSQL
- How to use ROW_NUMBER Function in SQL Server