transaction logs filling

[Former Member]

Hi,

Our transaction logs are getting filled up very rapidly. Within two hours of time about 60 GB of transactions logs

are getting filled. But the users activity is not that high and very normal.

As I am new to MSSQL, kindly guide us in this regard.

Best Regards,

DVRK

[Former Member]

Hi,

Hardware issue identified and the system is normal. Thanks

[Former Member]

Hi Rama Krishna,

A growth of 60gb in two hours is a concern.

Check out the activity in the database.

Below link may help.Unless create a message with microsoft and sap.

http://blogs.msdn.com/sqlblog/archive/2006/09/18/why-is-my-transaction-log-file-growing-rapidly-how-...

Regards

Ashok Dalai

[former_member256962]

If it grows rapidly like this..then please change the recovery model from full to simple for sometime which wont log much in tlog

[Former Member]

Hi,

T log generation is normal, you should not control on this, basically you cannot.

Huge data uploading is going on, it can be use RFC, can background job.

Nothing will happen, monitor it, and take tlog backup.

After full backup you can delete all tlogs.

Suman

[Former Member]

Hi,

Transaction log filling is just a simple case depends on the job load running on server.

To overcome the problem:

1: you have to do first the full database backup.

2: Then schedule the transactional log backup on regular basis from Microsoft SQL Server Management Studio.

The Tlog backup shrinks the sige of Tlog or the space will be able to reuse.

If shrinking is not done with Tlog backup please use DBCC SHRINKFILE sql statement as:

DBCC SHRINKFILE (<transaction_log filename>, <blocksize based on the size of the transaction log file>, TRUNCATEONLY)

Regards,

Shanker C

[Former Member]

Hi Rama,

Are you doing any client import process or any other process that cause filling the Transaction logs .

Go to SM37 and see the Acive jobs and check out any backgroung jobs running continuous causing this issue .

Also go to SM50 and see any long runnning activities going on .

To Free up Transaction logs space you can follow any of the below options :

1) Take Backup of Tlogs , it will work out and some free space will be generated.

2) You can shrink Transaction log . Refer note : 625546

regards,

Nibu