How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'
By FoxLearn 2/16/2024 4:34:01 AM 342
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 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
Categories
Popular Posts
Spica Admin Dashboard Template
11/18/2024