How to decrease the size of the SIDLOG1 file in a production server?

[Former Member]

Hi,

In my DEV and QAS environments, to reduce the size of the SIDLOG1 file, I normally shrink it in the SQL Server Management Studio.

At this moment, in my production environment I have the disk where is the SIDLOG1 file almost full.

Is it recommendable to shrink the SIDLOG1 file in a production environment or isn't?

If is not recommendable, which options do I have to reduce the size of the log file in a production environment?

Thanks,

Carlos

[Former Member]

Hi,

We can perform shrink of the file with either of the two options

Under SQL Management studio

Right-click on the database and choose '  Tasks - Shrink - Files'  

Change the "File Type" to "  Log"

Ensure that the option "  Release unused space" is selected

Click "OK"  

OR

https://support.microsoft.com/en-us/kb/907511

Br, Vaibhav

[luisdarui]

Hi Carlos,

See SAP Note 363018, solution, point D. Increasing and decreasing database files.

Best Regards,

Luis Darui

[Sriram2009]

Hi Carlos

At this moment, in my production environment I have the disk where is the SIDLOG1 file almost full.

1. Start the full DB backup,

2. Run the MS Sql Log truncate backup

3. Shrink the log DB to release the disk space.

If possible kindly share the ST04 screen shot.

 Is it recommendable to shrink the SIDLOG1 file in a production environment or isn't?

Yes, During off peak time you can perform the shrink log.if it is OLAP system you can set the parameters at DB level "auto shrink"

Regards

SS