How to reduce LDF file in sql for sharepoint

Here is the script for job that you need to run for decrease the LDF file

/***** Script start***

USE [DB_NAME];

ALTER DATABASE [DB_NAME] SET RECOVERY SIMPLE;

CHECKPOINT;

DBCC SHRINKFILE ([LOG_FileName], 1);

ALTER DATABASE [DB_NAME] SET RECOVERY FULL;

/***** Script End***

The above script reduce the log file up to 1,024 KB

Note: before doing any activity kindly make the back of each database.

Regards
3art Technology Experts
http://www.3art.tech

Comments

Updatepanel or Enable Ajax in SharePoint webpart

Dear All It is really giving me a hard to get this techniques if you want to run the update panel in sharepoint 2013 webpart then you need to initialize the script manage by code protected override void OnInit(EventArgs e) { base.OnInit(e); InitializeControl(); // Register the ScriptManager ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page); if (scriptManager == null) { scriptManager = new ScriptManager(); scriptManager.ID = "ScriptManager1"; scriptManager.EnablePartialRendering = true; ...

SQL SPLIT FUNCTION or String_split sql function alternative Very Information (Solved)

Dear All, Today i created a form with the checkbox list and store the value in the sql with comma seprated way. It was strange for me that the split_string function is not supported in sql 2014, so i have created split function that will help to split the comma sepearted values CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1)) returns @temptable TABLE (items varchar(8000)) as begin declare @idx int declare @slice varchar(8000) select @idx = 1 if len(@String)<1 or @String is null return while @idx!= 0 begin set @idx = charindex(@Delimiter,@String) if @idx!=0 set @slice = left(@String,@idx - 1) else ...

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All When trying to open a PDF file from a mapped drive in SharePoint 2010. You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com

Search This Blog