Admin-Ahead Community
Windows => General Windows => Topic started by: dustin on September 06, 2014, 03:01:45 pm
-
SQL server issues the error "The transaction log for database is full due to 'log_backup" while accessing the database.
The issue is due to SQL log file grow very large and consume too much space over server.
Following steps help me to sort the issue.
1.Open Microsoft SQL Server Manager Studio to connect with SQL Database
2.Select the database.
3.Execute T-SQL Script below by clicking Execute Button or press F5 Key.
USE your_db_name_here
GO
ALTER DATABASE your_db_name_here SET RECOVERY SIMPLE
DBCC SHRINKFILE(2,0)
ALTER DATABASE your_db_name_here SET RECOVERY FULL
GO
===