SharePoint 2013: The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered

When I am trying to open sharePoint 2013 Powershell

I am getting below error

“The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered”

Add the current user as powershell admin

Close the Power shell and open it again , now you can access it with out any error

WH

SharePoint 2013 Installation Error AppFabric, AppFabric installation failed because installer MSI returned with error code : 1603

SharePoint 2013 Prerequisites fails with MSI Installer error code 1603 while installing AppFabric 1.1

• Right Click “My Computer”
• Click “Properties”
• Go to “Advance” Tab
• Click at “Environmental Variables”
• Look in to System Variables.
• Find “PSModulePath” 
• Click “Edit”

And Verify the Entry should look like below

C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;c:\Program Files\AppFabric 1.1 

if you have different value then just just paste the above value.

Install AppFabric using below command.

Open Powershell and go to the AppFabric Path and Run the Command

\WindowsServerAppFabricSetup_x64 / i CacheClient, CachingService, CacheAdmin / gac

after executing the command , wait for few mintues and open the control pannel to see the installed programs

Network Load Balancing Using Windows Server 2012 For SharePoint 2013

Consider the Example That i have 2 Front-End server and One DNS record for Load Balance

Server Name	Role	IP
SP2013-FE01	Front end 1	192.168.137.15
SP2013-FE02	Front end 2	192.168.137.16
SPS2013	Load Balancer Name	192.168.137.30

SP2013-FE01 Sever

Step 1: Open Server Manager

Step 2: Click Manage on Right Top and Select “Add Role and Features”

Step 3: Leave every thing Default and Click Next

Step 4: "Select Installation Type"Leave Default and Press Next

Step 5: “Selecting Destination server “Leave Default and Press Next

Step 6: “Selecting Role “Leave Default and Press Next

Step 7: “Selecting Feature “Select Network Load Balancing After checking the Check box it will prompt for Extra Features.

Step 8: Select Extra Feature Required for Network Load Balancing and Press Add Features and will return to main features screen, Press Install

Installation Process will start, Wait for Completion of installation

SP2013-FE02 Server

Open The Second Front server and Repeat the Step 1 to step 8.

Configuration of Network Load balance.

Open the Server First Server SP2013-FE01

Step 1: Open Server Manager and Click Tools and Select Network Load Balancing manager.

Step 2:   From Menu select Cluster and Sub Menu New.

Step 3: Enter the first Host Name, in current scenario I am using SP2013-FE01 and Press Connect

After connecting successfully it will add in interfaces And Press Next

Step 4: New Cluster -- > Host parameters  make sure for first node Priority  is select  1 from Drop down and Default state is to be selected as started .

Step 5: Define Cluster IP -> Press Add Button to Add cluster IP.

Step 6: Enter IP for Cluster in My Case I am using 192.168.137.30 and Subnet is 255.255.255.0 and Press OK

Step 7: Select the Cluster from Drop Down, (automatically selected if not selected then select manually) Enter the Full Internet name and From Cluster Operation Mode Select Multicast and press Next

Step 8: Port Rules it will select from 0 to 65535 if you want to edit it, otherwise leave as default and Press Finish.

Now you can see you Cluster , One node is already added, 

Add Second Node to the NLB Cluster

Right Click on Cluster  -"Add Host to the Cluster"

Enter Host IP and Press Connect after Press Connect it will added into interfaces.

Setting the host parameters, For This Node select priority 2 and state as "started"

Press Next and it will prompt for Ports setting , If you want to change can edit other wise leave it default.

Verify the nodes.

Your backup is from a different version of Microsoft SharePoint Foundation and cannot be restored to a server running the current version

Source Server:

Running on SharePoint 2010 with SP1 (Installed SP1 manually)

Version Information:

Target Server:

Running on SharePoint 2010 With SP1 (Newly configure using SharePoint 2010 With SP1 Media)

Version information:

But I was trying to restore using Power Shell I am getting the Error for version is not same.

Your backup is from a different version of Microsoft SharePoint Foundation and cannot be restored to a server running the current version. The backup file should be restored to a server with version 14.0.0....   Or later

Versions are same, that’s why I was not sure what the difference is,

I just verify the Installed Update I found at Source and Target server are different in the terms of SharePoint Updates.

1. Download required Updates
2. Installed on Target server
3. Restart is required.
4. Run the configuration Wizard

 you can Find Required Update and hot fix information at 

Download HotFix and CU

After that doing the above steps I am able to restore my site collection backup.

Restore SQL DataBase Backup On same or Different Server Using SQL Command

Most of the time i am struggling to restore to the back from interface, Different types of errors every time i need to face,  Using SQL command its more easy just have to make sure about the file names are correct and  current user have permissions to access.

You must have a Valid SQL Backup file with .bak extension, You can use this Sql command to restore the back on the same server or different Server.

Open SQL Server
Click at New Query
use the below query , just the required Parameters according to you files and locations.

Restore filelistonly from disk = 'FULL-PATH\FileName'

Go

restore database DatabaseName

from disk = 'FULL-PATH\FileName'

with

move 'Logical Name for Data File to 'FULL-PATH\FileName.mdb'

move 'Logical name for Log Fileto 'FULL-PATH\FileName.ldf'

Example

Restore filelistonly from disk = 'C:\Backups\WSS_Content_2010_Portal-Full-Database-Backup'

go

restore database WSS_Content_2013_portalTest

from disk = 'C:\Backups\ WSS_Content_2010_Portal-Full-Database-Backup'

with

move 'WSS_Content_2013_portalTest' to 'C:\Backups\WSS_Content_2013_Portal.mdf',

move 'WSS_Content_2013_portalTest_log' to 'C:\Backups\WSS_Content_2013_Portal_log.ldf'

Programmatically get choice values from SharePoint List

Step 1: Create a Simple Method or use Code Directly in Existing Method.

        /// <summary>
        /// Get Choice Column Value from List
        /// </summary>
        /// <param name="List"> List Name</param>
        /// <param name="Field"> Field Name</param>
        /// <returns> List<String> Containing the Choice Column Values</returns>

        public List<string> GetChoiceColumnValues(string List, string Field)
        {
            List<string> Choices= null;
            try
            {
                using (SPSite site = new SPSite(SPContext.Current.Web.Url.ToString()))
                {
                    using (SPWeb web = site.OpenWeb())
                    {
                        SPList objList = web.GetList(List);
                        SPFieldChoice field = (SPFieldChoice)objList.Fields[Field];
                        Choices= new List<string>();

                        foreach (string str in field.Choices)
                        {
                            Choices.Add(str);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Response.Write("Get Values : " + ex.Message);
            }
            return Choices;
        }

how to Get Values from Strings List

List<string> objFields = GetChoiceColumnValues(SPContext.Current.Web.Url.ToString() + "/Lists/ListName", "Fieldname");
            foreach (string item in objFields)
            {
                item.ToString();

            }