Monday, February 14, 2011

FIX Transaction Log Full Error 9002

We have to find out full transaction log of any database depends on what condition caused the log to fill entire drive.

Here is the script for releasing transactional log from the database

STEP-1
Run the below script for finding logical name of your log file 

EXEC SP_Helpdb 'XXX'
GO 

STEP- 2
USE XXX
GO
CHECKPOINT
GO
BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
dbcc shrinkfile ('XXX_log',TRUNCATEONLY)
go
dbcc SHRINKFILE (XXX_log, 1)
GO

Change your database name with XXX and logical name of your database log file with XXX_log.
Troubleshoot a Full Transaction Log. A transaction log grows unexpectedly or becomes full on a computer. Troubleshooting a Full Transaction Log (Error 9002). SQL Server Error 9002. SQL Transaction Logs are Full. Error 9002 transaction log for database is full. Error 9002. The Transaction Log for MSDB database. The transaction log for database 'tempdb' is full. tempdb reporting Error: 9002 log full‎. the transaction log for database is full sql server 2012 Error 9002. the transaction log for database is full sql server 2008 R2 Error 9002. Transaction log is full. How do I shrink it. SQL error 9002 while Login. MSSQLSERVER_9002. Log file full - Error 9002 State 6. Transaction Log Full with error 9002 rollback transactions. Tempdb Errror Log Is Full. Database %d was shutdown due to error 9002 in routine. Transaction Log Truncation. Help! The transaction log is full error in SSIS. How can I keep the log from filling up. Transaction log getting full frequently. Why is my transaction log full. Log_Reuse_Wait_Desc ACTIVE_TRANSACTION. Transactional log grows abnormally to. 

0 comments:

Post a Comment