How to fix 'The transaction log for the database is null due to OLDEST_PAGE'
By FoxLearn 2/16/2024 4:36:25 AM 117
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 export data to .csv file
- How to Read Excel file and Import data from Excel to SQL Server in C#
- How to Create a backup SQL Server in C#
- How to Search data from Database in C#
- How to rename a column name in SQL
- How to add primary key to existing table in SQL Server
- How to add index in SQL Server
- How to Download and Restore Northwind database to SQL Server