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

Managed Path with WildCard and Explicit Inclusion

I thought to put an article on Managed Paths in SharePoint covering their use with Explicit Inclusion and Wildcard Inclusion and also how to use them in Real World scenarios So let’s see what Managed Path is Managed Path: By default when we create Site Collections inside a Web Application in SharePoint they are created with the URL “http://servername:portnumber/site”.  But if we want to have a specific URL other than “/site” we need to create Managed Path. So as an example if we want to create Site Collections for IT and HR Dept and want to have URL's like “http://servername:portnumber/IT” and “http://servername:portnumber/HR” we can do with the help of Managed Paths. Managed Path helps to have site collection with the URL other than “/site”. Managed Path can be created in Central Administration in Application Management under SharePoint Web Application Management. When we create Managed Path either we can select Explicit Inclusion or Wildcard Inclusion. So let’s see what ...
Read more

List All SharePoint 2010 PowerShell Commands

Use this PowerShell command to output a list of all cmdlets that are found within the SharePoint 2010 namespace: Get-Command –PSSnapin “Microsoft.SharePoint.PowerShell” | format-table name > C:\SP2010_PowerShell_Commands.txt If you would like a little more detail, then try this one: Get-Command –PSSnapin “Microsoft.SharePoint.PowerShell” | select name, definition | format-list > C:\SP2010_PowerShell_Commands.txt
Read more

Set a Service Application Administrator in SharePoint 2010

Image
SharePoint 2010 allows Farm Administrators the ability to delegate administrators for individual Service Applications. Once provisioned, the Service Application Administrator will gain access to a security-trimmed Central Administration where they can only access and configure the roles granted to them. This is perfect for scenarios when perhaps you want to offload the Profile, Managed Metadata, or Search features off onto other departments. Let’s walk through how we can use SharePoint 2010 to provide least privilege access to the User Profile Service Application to only Manage Audiences. Our user that we want to delegate Audience control is SOMEUSER (Domain\UserName). If we were simply to send him the link to Central Administration, then he would be met with an Access Denied page. Now, logged in as a Farm Administrator, go to Application Management > Manage Service Applications. Next, highlight the desired Service Application, in this case the User Profile Service Ap...
Read more