How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'
By FoxLearn 2/16/2024 4:34:01 AM 78
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
- 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
Categories
Popular Posts
Visual Studio: Auto increment version
04/01/2024
What is ARM architecture?
04/01/2024