The transaction log for database 'Sharepoint_Config' is full

1. On your SQL Server -> open the SQL Server Management Studio.

2. Connect to the local SQL Server

3. Right click SharePoint_Config -> Properties -> Options.  Change Recover Model from Full to Simple.

4.  Click OK.

5. Right click SharePoint_Config, go to Tasks -> Shrink -> Shrink Files.  Select a File type of Log, then Shrink

This should solve the problem.

Comments

Post a Comment

Popular posts from this blog

Activating a SharePoint Feature on Multiple Sites or Site Collections using PowerShell

I need to either activate or even deactivate certain features on multiple site collections. So the below script will allow you to do this.. First step create a text file in the below format, you only need to define the URL for each Site collection or site. SiteURL http://sharepointsuresh/sites/site1 http://sharepointsuresh/sites/site2 http://sharepointsuresh/sites/site3 http://sharepointsuresh/sites/site4 http://sharepointsuresh/sites/site5 http://sharepointsuresh/sites/site6 You can list all features installed on your sites by using the following PowerShell: Get-SPFeature | Sort -Property Scope,DisplayName | FT -GroupBy Scope DisplayName,Id Then use the below PowerShell Script: $SiteList = Import-Csv Sites.txt ForEach ($item in $SiteList) {             If ($item -ne $null)             {                 Write-Host "Activated Branding Feature for: $($item.SiteURL)" -...
Read more

Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException", SharePoint exception after applying cumulative update\service pack

After applying a cumulative update on one of my SharePoint server, tried to run configuration file using psconfig.exe -cmd upgrade -inplace b2b -wait -force command, i got an error saying that "Exception: Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException: An upgrade conflict has occurred and you must re-try this action" We can fix this exception by setting line-update-running property to true. To do that Open command prompt with administrator privileges and navigate to bin folder (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Bin) and execute following command stsadm -o setproperty -pn command-line-upgrade-running -pv Yes By running this command on SharePoint server, it will reset the command-line-upgrade-running property. We need to execute this command on all the SharePoint servers in the farm after upgrading. Once we are done with running this command, we have to run config command as psconfig.exe -cmd upgrade -inplace b2b –wai...
Read more

Change SharePoint Site Time Format

Image
In SharePoint calendar by default we can see the view as Day/week in 12 hour format, not in 24 hour format. We can to change the format from 12 hour to 24 hour through UI or using Power Shell commands. We can change that through UI by following steps, Navigate to SharePoint Site settings page and in Site Administration section click on “Regional settings” link In Time format drop down select 24 hour format. Click on ok to save the settings. We can change the format using following Powershell commands, $site = Get-SPSite <SiteCollectionURL> $web = $site.OpenWeb() $web.RegionalSettings.Time24=$True $web.RegionalSettings.FirstDayOfWeek=1 $web.Update() $web.Dispose() $site.Dispose()
Read more