Friday, February 23, 2018

Site backup through Central Administration site

You can take the site collection back up through central administration site apart from using the BackUp-SPSite and Restore-SPSite PS command. The advantage of this approach is getting the status report while your site being backed up by the timer services.

 You can prefer this backup approach, if you are continuously taking the back up of huge site because It lets the administrator to have his/her network shared location which can be attached the high end storage medium (SAN). Before this, you need to create the shared folder location and set the access permission (Read and Write) for it.

It support the granular backup approach

You can also restrict the user permission over this folder by selecting the specific user or group.

 I have the small site collection at my machine and backed up through this approach.One should aware of the advantages and disadvantage by comparing the PS Commands BackUp and Restore. Once you backed up the site collection, you need to verify its integrity this where lack this approach. BackUp-SPSite has the parameter UseSQLSnapshot.

After successful backup task completion

Sunday, February 11, 2018

SharePoint Online SystemUpdate Vs Item Update

In CSOM / REST Api for SharePoint Online, We have new method for List Item called "SystemUpdate".

This is an attempt to bring the same functionalities of Server Side Object Model (SSOM) into SharePoint Online also.

This method is very useful, if you wanted to retain the Modified By and Modified Date on your SharePoint list for Auditing purpose when you migrate to SharePoint Online.

Its appropriate to understand the difference but List Item's Update method and System Update method.

If you want to update the fields Modified, Modified by then you can explicitly assign the new values to its field or you can also ignore when you call the method Item.Update().

If you wish to retain the Modified and Modified By column but wanted to update the rest of the fields, then you should use the Item's SystemUpdate method.

var pwd = "yourpassword";
            var securePassword = new SecureString();
            foreach (char c in pwd)

            var onlineCredentials = new SharePointOnlineCredentials("", securePassword);
            var context = new ClientContext("");
            context.Credentials = onlineCredentials;
            List oList = context.Web.Lists.GetByTitle("Friends");
            ListItem item = oList.GetItemById(35);
            item["xm2s"] = "+91-xxx-7887-xxxx";
            item["Modified"] = DateTime.Now.AddDays(-7);

Image 1

Earlier my record has old value for the column
Image 2
After I call the SystemUpdate method as above Image 1, It updates only the mobile not Modifield column.

Thursday, February 08, 2018

SharePoint PnP PowerShell on Windows 2008 R2

The new SharePoint PnP PowerShells for SharePoint Online is based on CSOM implementation and it can work for On-Premise versions of SharePoint 2013 and SharePoint 2016.

To install the module for SharePoint PnP, Your PowerShell engine version must be greater than 4.0.
You can use the below command to determine the current version of your PowerShell Engine.


It will shows the major , minor, Builder and revision number.

If your major version is less than 4.0 , then you need to upgrade it to next major version.

You can download and install the "Windows Management Framework 5", link

In my case, I am using the Windows 2008 R2 SP1 and selected the relevant installation file from download page


Once you upgraded to next version, you need to install the Module for "SharePoint PnP PowerShell Online."

Post upgrade , I can install the SharePoint PnP PowerShell for Online.

Friday, September 08, 2017

Thank you Microsoft

Thank you so much for the free trial for 180 days on SharePoint 2013, SQL Server and Windows 2008 R2 Standard , It was really helpful to sharpen my skills in SharePoint , Office 365 technologies . Without this offer, I would n't done this much. I was about to reinstall the another installation on my machine. But I feel guilty of doing so with out saying BIG THANKS to Microsoft . 

Thanks a lot Microsoft.