SharePoint Backup and Restore

Backup

stsadm -o backup -url http://sharepointsite -filename D:\Backup\backup.bak

Restore

stsadm -o restore -url http://sharepointsite -filename D:\Backup\backup.bak -overwrite

Anonymous Users cannot open XLSX files from a SharePoint document library

$siteUrl = "http://URL_of_your_SITE";
$site = New-Object Microsoft.SharePoint.SPSite($siteurl);
$web = $site.OpenWeb();
 
$enumPerms = [Microsoft.SharePoint.SPBasePermissions];
 
Write-Host $web.AnonymousPermMask64;
$web.AnonymousPermMask64 = $web.AnonymousPermMask64 -bor $enumPerms::OpenItems
$web.Update();
Write-Host $web.AnonymousPermMask64;
 
$web.Dispose();
$site.Dispose();

http://support.microsoft.com/kb/2498047

Unable to add selected web part

ERROR:
Assemblies that implement ASP.NET Web Parts and are installed into a partially trusted location, such as the bin directory, must be compiled with the AllowPartiallyTrustedCallersAttribute set for import to succeed.

SOLUTION:
Add [assembly:AllowPartiallyTrustedCallers] to AssemblyInfo.cs

SharePoint 2010 Change your display of welcome name

In Powershell:

Set-SPuser -identity “DOMAIN\accountname” -DisplayName “Name Surname” -web <URL of Site>

SharePoint Config database log file too big. Solve it! :)

USE SharePoint_Config
GO
ALTER DATABASE SharePoint_Config SET RECOVERY SIMPLE
DBCC SHRINKFILE(N'SharePoint_Config_log', 1)
ALTER DATABASE SharePoint_Config SET RECOVERY FULL
GO

XPath: Get attribute by maximum value

xpath: /root//node[not(@y <= preceding-sibling::node/@y) and not(@y <=following-sibling::node/@y)]

XmlDocument doc = new XmlDocument();
doc.Load("data.xml");
XmlNodeList nodeList = doc.SelectNodes("/root/node[not(@score <= preceding-sibling::node/@score) and not(@score <=following-sibling::node/@score)]");
StringBuilder output = new StringBuilder();
            output.Append("<b>");
            for (int i = 0; i < nodeList.Count; i++)
            {
             output.Append("<b " +
                 nodeList[i].ParentNode.Attributes["parentAttribute1"].OuterXml + " " +
                  nodeList[i].ParentNode.Attributes["parentAttribute2"].OuterXml + ">");

                output.Append(nodeList[i].OuterXml);
                output.Append("</b>");
            }

            output.Append("</b>");

Sign out problem in SharePoint 2010

I solved my problem :)

  if (HttpContext.Current.Request.Cookies["FedAuth"] != null)
  {
    HttpCookie requestCookie = new HttpCookie("FedAuth");
    requestCookie.Secure = false;
    requestCookie.Expires = DateTime.Now.AddYears(-1);
  }
            FederatedAuthentication.SessionAuthenticationModule.SignOut();
FormsAuthentication.SignOut();

Response.Redirect("~/redirecturl");