If your SQL Server is running some out of space or having less remaining space it would be ideal to shrink/truncate the size of these log files in a timely manner. The below steps helps in resolving this issue
You’ll begin by logging into the server hosting the SQL Server SharePoint databases, and open SQL Server Management Studio . Be sure you are connected to the instance of SQL Server that contains the SharePoint content means your content server.
Locate the database that has the ginormous t-log file and use either of the following sets of steps to shrink the ginormous transaction log file down to a reasonable size.
- Expand the Databases node and expand User Databases
- Right-click the database, and click Properties, which opens the Database Properties dialog box.
- In the Select a page pane, click Options.
- View the current recovery model in the Recovery model list box, which should be set to Full
- Click the dropdown arrow in the recovery model section and select the Simple recovery model
- Click OK.
- 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, and you can specify the file size by supplying a value in the Shrink file to option.
Note: the shrink may take some time depending on how large the file is and how much it has to shrink.
- After the shrink completes, change the recovery model back to Full by clicking the recovery model dropdown arrow and selecting the Full recovery model