on 07-27-2015 10:38 AM
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.
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.