MS_SQL Shrinking Log Files.

[Former Member]

Hi Experts,

We have checked the documentation which have been received from SAP (SBO_Customer portal), Based on the Early Watch Alert.

AS per SAP requsition we have minimized the size of 'Test Database Log' file through MS_SQL Management Studio.(Restricted file size 10 percent, size 10 MB)

Initially it was 50 Percent, 1000 MB

Doubt is:

Is that any problem will occur in future regarding this changes of 'LOG FILES'.

Kindly help me.

Based on your reply ...

i will update in live production database....

By

kart

[former_member583013 · Accepted solution]

You should not have any problems due to this change

Also read this note https://service.sap.com/sap/support/notes/625546

[Former Member · Accepted solution]

Hi Suda,

Is that possible to set 'Log file' shrink settings in MS_SQL (Maintainence Plan).

by

kart

[Former Member · Accepted solution]

This is one time setting. You don't need a plan to do it.

[Former Member]

The risk to shrink log file is fairly small. Current hardware and software has much better reliability than before. When you shrink your log file, you just lose some history which nobody even know there is any value in it.

On the contrary, if you keep very large log file, it may cause more troubles than doing anything good.

Thanks,

Gordon