How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'
By FoxLearn 2/16/2024 4:34:01 AM 398
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 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#
Categories
Popular Posts
11 Things You Didn't Know About Cloudflare
12/19/2024