Truncate SharePoint Log Files for All the database in SQL Server


Truncate Log Files for All the database in SQL Server1. Perform full backup of all your database2. Open your SQL Management Studio 3. Click on New Query4. Insert the code and click Execute SQL 2008 use masterDECLARE @Statement varchar (4000)SELECT @Statement = ”SELECT @Statement = @Statement + ‘USE [?];’SELECT @Statement = @Statement + ‘DECLARE @Log_Logical_FileNameContinue reading “Truncate SharePoint Log Files for All the database in SQL Server”