Transanction Log is Full - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Transanction Log is Full

Author

Topic

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-09-14 : 09:47:26

Hi guys got the following entery in log file,
"2007-09-03 18:31:36.71 spid39 The log file for database 'UAT_FR_FPFF_SPORTING' is full. Back up the transaction log for the database to free up some log space.."

Could you help me to step by step to fix this issue please

Yogesh V. Desai. | SQLDBA|

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2007-09-14 : 09:59:02

Issue check point that will commit the uncommited transactions.

Backup the databse will do the same.

dbcc shrinkfile('log file path',size)....

If all these are not working then

take a full backup,change the recovery mode to simple and then run dbcc shrinkfile('log file path',size).It will definitely work.

RKNAIR

Kristen
Test

22859 Posts

Posted - 2007-09-14 : 10:06:22

Note that either your disk is full, or the database has a fixed size (rather than automatic extension).

Possibly your database is in FULL Recovery Model and you have NOT been making regular Tlog backups - in which case the Tlog .LDF file is probably huge compared to the Data .MDF file

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-09-14 : 10:44:37

hi Guys I can see the more in my log files

The log file for database 'UAT_FR_AI_ED' is full. Back up the transaction log for the database to free up some log space..
Could not write a CHECKPOINT record in database ID 32 because the log is out of space.
Error while undoing logged operation in database 'UAT_FR_FPFF_BOAVISTA'.
Error while undoing logged operation in database 'UAT_FR_FPFF_BOAVISTA'. 2007-09-03 18:31:34.50 Recovery is checkpointing database 'UAT_FR_KEYNESQS_LEV' (12)
transactions rolled forward in database 'UAT_FR_FPFF_SPORTING' (37).
0 transactions rolled back in database 'UAT_FR_FPFF_SPORTING' (37).
Recovery is checkpointing database 'UAT_FR_FPFF_SPORTING' (37)
L:\mssql\applog\UAT_FR_FPFF_SPORTING_log.ldf: Operating system error 112(error not found) encountered.
The log file for database 'UAT_FR_FPFF_SPORTING' is full. Back up the transaction log for the database to free up some log space.

Need serious help on this

Yogesh V. Desai. | SQLDBA|

Kristen
Test

22859 Posts

Posted - 2007-09-14 : 11:40:22

Did you check if your disk was full?

Did you read the link I posted?

If so make some space available, and backup the database.

If space is still really tight consider shrinking the TLog, but I recommend that you only do this if you know that your TLog is exceptionally large for some reach e.g. you never backed it up, or you did some massive one-off delete). Otherwise the Tlog will be back the same size by tomorrow ...

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources