How do I shrink a sharepoint log file?
Right-click on the same database name and click Task-> Shrink-> Files. Use the File type drop-down menu and choose Log. You can use the default setting of Release Unused Space or select Reorganize Pages before releasing unused space. You can specify the file size by supplying a value in the Shrink file to option.
How do I reduce the size of my SQL server log file?
Use dbcc shrinkfile or Management Studio to shrink the log files. Step #2 will do nothing until the backup mode is set. You have to shrink & backup the log a several times to get the log file to reduce in size, this is because the the log file pages cannot be re-organized as data files pages can be, only truncated.
Is there a way to shrink a SharePoint transaction log?
After executing the SQL script to truncate transaction log in my SharePoint 2010, it recovered me considerable space now! Shrinking can be done from SQL Server Management Studio also. Go to SSMS >> Right-click the target Database >> Tasks >> Shrink >> Files (or Database) Select the File Type and click on “OK” button to start shrinking.
How to reduce file size in SharePoint database?
In case you don’t find any decrease in log file size, Try setting the Database to Single user Mode (Go to : Database Properties >> Options >> Set “Restrict Access” to Single User ), repeat the above steps and then revert the status again to Multi_User! Information Technology Professional with Two decades of SharePoint Experience.
How big is a SharePoint transaction log file?
As the number of users and transactions are growing high log file size file will grow much faster than transactional DB. That is what exactly happened in my case the primary DB is only 120GB but whereas log file is 370GB and now server admin team has started sending emails asking me to delete/move this log file.