SQL error 9002 while Login SAP

[Former Member]

Hi All,

Today we were upgrading ABAB and BASIS support pack . while the proccess was going we had an error "SQL error 9002 transaction log is full" after that session got terminate . now we unable to login SAP . We are getting this message "SQL error 9002 transaction log is full" at time of login . Now how do I login SAP and clear the transaction log. what is the solution of this problem .

Thanks in Advance

Jitendra Singh

[Former Member · Accepted solution]

Hi,

backup the transaction log and then truncate it.

Use SAP note 421644.

Regards,

Sachin Rane.

[Former Member]

Hi All

kindly help me out I tried login a solman  system this morning  and the error prompt SQL ERROR 9002 WHEN ACCESSING TABLE SNAP  kindly with step to fix this issue

[Former Member]

solved

Thanks to all.

[Former Member]

Hi,

Please find the link below. Even you can increase the size of log if space is available on the disk. You can find few options in the link below.

[http://msdn.microsoft.com/en-us/library/ms175495.aspx]

Hope this helps.

Manoj

[Former Member]

Hello Jitendra,

whenever you usually do such type of basis tasks like patch upgrades and all it is preferable to switch off the logging so that transactional logs doesnt increase

I would recommed you to go to SQL server studio and change the automatic logging to simple...then you will not face any issues of transactional logs

but remember after your work is over switch automatic logging to full

Let me know of any questions

Rohit

[Former Member]

Dear,

Take backup of Tlog through query in management studio.

BACKUP LOG PIP to disk ='G:\Logbackup\ttt1.bak' with INIT

DBCC SHRINKFILE('<log file name>')

Execute above command 2-3 times with different backup file name.

Regards,

Nikunj Thaker.