Transaction Log & autoshrink option

[ashish_vikas]

Hello friends,

We are performing EHP upgrade for our SAP systems on MSSQL 2008. During upgrade, in phases like Dbclone /Shadow Import we are getting Transaction Log Full for MSSQL.

Transaction Log is set to 50 GB and transaction log backup frequency is 1 hour(frequency can not be reduced).

Wanted to understand if autoshrink option can be helpful and if yes.. HOW ?

best reagrds

ashish

[former_member188883 · Accepted solution]

Hi Ashish,

Can you disable log my changing the mode to simple ?

Regards,

Deepak Kori

[ashish_vikas · Accepted solution]

Can you please provide more details on this.

best regards

ashish

[former_member188883 · Accepted solution]

Hi Ashish,

Refer SQL blog in the link below

http://msdn.microsoft.com/en-us/library/ms189275.aspx

Hope this helps.

Regards,

Deepak Kori

[former_member188883 · Accepted solution]

Hi Vikas,

Hope your issue is resolved. You may close this thread.

Regards,

Deepak Kori

[Former Member]

Hello,

During inputs (in SAP upgrade tool) the system ask if you want transaction log on or off. you can put the log in simple and made backups when the SAP tool said/ask for them (between activities). This is the better choise.

The auto shrink option must set off and means "downsize a SAP database" in this case a log file. So your problem is not reduce the log file but the activity of log file. This activity needs space if you don´t do backups or put the logfile in "simple" mode. 

Best regards

Joao Vagarinho