Backup / Restore SharePoint site collection using PowerShell or STSADM commands

• Backup Using PowerShell

Backup-SPSite <URL of the site collection (Ex, http://server_name/sites/site_name)> -Path <full path to the backup file (Ex, C:\Backup\site_name.bak)>

• Backup Using STSADM

stsadm -o backup -url <URL of the site collection (Ex, http://server_name/sites/site_name)> -filename <full path to the backup file (Ex, C:\Backup\site_name.bak)> -overwrite

• Restore Using PowerShell

Restore-SPSite <URL of the site collection (Ex, http://server_name/sites/site_name)> -Path <full path to the backup file (Ex, C:\Backup\site_name.bak)> -Force 

• Restore Using STSADM

stsadm -o restore -url <URL of the site collection (Ex, http://server_name/sites/site_name)> -filename <full path to the backup file (Ex, C:\Backup\site_name.bak)> -overwrite

Note: Using of -overwrite or -Force to overwrite an existing backup file or site collection if it already exists.

SharePoint configration database connection string

Connection string for SharePoint configuration database can be found on SharePoint servers registry under below registry path registry key dsn

• SharePoint 2007

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDB

• SharePoint 2010

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDB

• SharePoint 2013

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDB

Install SharePoint solution using PowerShell or STSADM commands

First make sure to log in to SharePoint server (Application server is preferred) with Farm admin account and run PowerShell or command line as administrator

• Install Solution Using PowerShell

> Add-SPSolution <solution file name>
> Install-SPSolution -Identity <solution name> -WebApplication <virtual server url> -GACDeployment

• Install Solution Using STSADM

> stsadm -o addsolution -filename <solution file name>
> stsadm -o deploysolution -name <solution name> -url <virtual server url>

• Uninstall Solution Using PowerShell

> Uninstall-SPSolution -Identity <solution name> -AllWebApplications
> Remove-SPSolution -Identity <solution name>

• Uninstall Solution Using STSADM

> stsadm -o retractsolution -name <solution name> -url <virtual server url> -immediate
> stsadm -o deletesolution -name <solution name>

Read Only / Non-Editable TextBox

To make Text box Read only (or Non-Editable) without disable it and appear on gray style by adding the following attributes to TextBox tag

<asp:TextBox ID="txtBox1" runat="server" onkeypress="return false;" onpaste="return false;" Text="Read Only TextBox" />

OR

<asp:TextBox ID="txtBox2" runat="server" ReadOnly="true" Text="Read Only TextBox" />

Also you can use below attributes but it works only with IE 

contenteditable="false" Or unselectable="on"

SharePoint Service Account Properties

1. In Active Directory Users and Computers, view the Properties of the user account.
2. On the Account tab, set the following Account options.
3. Uncheck User must change password at next logon.
4. Check the option User cannot change password.
5. Check the option Password never expires.
6. Click OK.