File Growth / Log Space / Transaction Log is Full

Issue

While trying to run the program following message appears.

“File Growth / Log Space is full. Delete Transaction Log file”

Solution

Close all application on all nodes (if running). Run the following commands using Query Analyzer of MSSQL Server.

BACKUP TRANSACTION Data WITH no_log

GO

CHECKPOINT

GO

/* IF YOU ARE USING SQL SERVER 2000 USE FOLLOWING QUERY */

DBCC SHRINKDATABASE(‘Data’,10)

/* IF YOU ARE USING SQL SERVER 7.0 USE FOLLOWING QUERY */

DBCC SHRINKDB(‘Data’,10)

GO

CHECKPOINT

GO