cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction Log reuse

Former Member
0 Kudos


Hello,

I've configured the transaction log with log file of 1GB, the recovery mode is SIMPLE but I'm getting this error:

The transaction log for database 'BWD' is full. To find out why space in the log cannot be reused, see
the log_reuse_wait_desc column in

The log_reuse_wait_desc is with NOTHING.

What I need to configure to reuse the transaction log when It has been filled?

Regards.

Accepted Solutions (0)

Answers (2)

Answers (2)

luisdarui
Active Contributor
0 Kudos

Hi Ruben,

Using the recovery mode "SIMPLE" is suggested only for a few situations (during upgrade for example). But it doesn't mean that your Transaction Log cannot get full. If you have a big transaction (larger than your Transaction Log) it may get full.

Please check the following link which explains how to use DBCC OPENTRAN to check which transactions are active and not allowing the transaction log to be truncated or recycled:

DBCC OPENTRAN (Transact-SQL)

You also might want to extend your current transaction log (autogrow is a good choice or set up the size according to the transaction/activity you're performing).

remark> 1GB for Transaction Log in SAP system is a very small log size. Try increasing it to 5GB for example. And for Production, activate FULL RECOVERY and start the Transaction log backups as soon as possible!

Regards,

Luis Darui

Sriram2009
Active Contributor
0 Kudos

Hi Ruben

What I need to configure to reuse the transaction log when It has been filled?

To resue the space you have to run the truncate log backup, Refer the SAP Note 421644 - SQL error 9002: The transaction log is full

BR

SS