How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'
By FoxLearn 2/16/2024 4:34:01 AM 125
This post show you how to fix 'The transaction log for database 'x' is full due to 'ACTIVE_TRANSACTION' in SQL Server.
Right click on your database, then select Properties.
Next, Select Options, then change the Recovery mode from 'Simple' to 'Full'
Finally, Right click on your database, then select Tasks =>Shink =>Database
Do the same way Tasks =>Shink =>File
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
Categories
Popular Posts
C# Tutorial
07/20/2024
How to Download Microsoft SQL Server
06/22/2024
What Are RESTful Web Services?
02/19/2024
What is ARM architecture?
04/01/2024