Skip to Content
0
Former Member
Jul 08, 2014 at 05:49 PM

Transaction Logs - Full disk problem

959 Views

Hello,

I´m facing mouth to mouth an strange situation.

The Backup of our SAP systems are setup through the transaction DB13 and the SQL Server devices. This task is working without problems, the backup completes with success.

The problem is with the Transaction Logs (Tlogs). Every month the Tlogs disk fills and the system stops because of that and to solve this, every month, I have to go to SQL Management Studio, change the recovery model to "Simple" and perform a shrink task to the Tlog file as you can see in the following image, in this way it release unused space:

My question is... it´s possible to shrink automatically the Tlog files every time the task of full backup completes with success?

Can you help me please?

Thank you,

samid raif

Attachments

SNAG-0693.jpg (185.8 kB)