SharePoint 2013 Visual Upgrade and Version Upgrade after Migration using PowerShell

Here we look how to perform visual upgrade of Site Collections after upgrade to SharePoint 2013. Visual upgrade is necessary after migration process to get new visual look of SharePoint 2013. Version upgrade is necessary to change it to 15 Hive, means compatibility level to current version SP 2013.
Note: Deploy custom Master Pages, Custom Solution etc before you attach content database. No error will show while opening site.
First, attach your existing content DB to new web application by using cmdlet-
Mount-SPContentDatabase “DBName” -DatabaseServer “ServerName” -WebApplication http://sitename
To check current compatibility level of content-db which you have attached. 
Run  Get-spsite cmdlet
Latest upgraded site listed as compatibility level 14 hive.

Second, Test your Site by using Test-SPSite.
Test-SPSite http://server/sitecollection
you can avoid warnings, it will be good if you remove errors before upgrade process.
At last run upgrade cmdlet for Visual upgrade and also pass version upgrade parameter for current version compatibility level- 15 hive.

Upgrade-SPSite http://server/sitecollection –VersionUpgrade

Once 100% completed, you will have the SharePoint 2013 visuals throughout your site collection.

Note: We determine here that already converted classic based authentication to Claim Based Authentication.

• The Upgrade-SPSite cmdlet activates the upgrade process for the specified SPSite object. You can also use this cmdlet to resume failed upgrades. When you use this cmdlet to initiate upgrade on an SPSite object, the object can be either a build-to-build or version-to-version upgrade. By default, the Upgrade-SPSite cmdlet operates as a build-to-build upgrade. 
• -VersionUpgrade parameter, specifies to perform a version-to-version upgrade on the SPSite object. When this parameter is set, it internally triggers all available build-to-build actions that are associated with the current site collection operating mode. Version-to-version actions follow to bring site collections to the next site collection operating mode inclusive of all new build-to-build actions that are associated with the new site collection operating mode. When this parameter is not set, it triggers only available build-to-build upgrade actions that are associated with the current site collection operating mode. Reference https://technet.microsoft.com/  

On next post see how to upgrade Sharepoint site collection from  Site Settings page of site collection.

SharePoint 2013 Visual Upgrade and Version Upgrade after Migration using PowerShell

Here we look how to perform visual upgrade of Site Collections after upgrade to SharePoint 2013. Visual upgrade is necessary after migration process to get new visual look of SharePoint 2013. Version upgrade is necessary to change it to 15 Hive, means compatibility level to current version SP 2013.
Note: Deploy custom Master Pages, Custom Solution etc before you attach content database. No error will show while opening site.
First, attach your existing content DB to new web application by using cmdlet-
Mount-SPContentDatabase “DBName” -DatabaseServer “ServerName” -WebApplication http://sitename
To check current compatibility level of content-db which you have attached. 
Run  Get-spsite cmdlet
Latest upgraded site listed as compatibility level 14 hive.

Second, Test your Site by using Test-SPSite.
Test-SPSite http://server/sitecollection
you can avoid warnings, it will be good if you remove errors before upgrade process.
At last run upgrade cmdlet for Visual upgrade and also pass version upgrade parameter for current version compatibility level- 15 hive.

Upgrade-SPSite http://server/sitecollection –VersionUpgrade

Once 100% completed, you will have the SharePoint 2013 visuals throughout your site collection.

Note: We determine here that already converted classic based authentication to Claim Based Authentication.
The Upgrade-SPSite cmdlet activates the upgrade process for the specified SPSite object. You can also use this cmdlet to resume failed upgrades. When you use this cmdlet to initiate upgrade on an SPSite object, the object can be either a build-to-build or version-to-version upgrade. By default, the Upgrade-SPSite cmdlet operates as a build-to-build upgrade. 
-VersionUpgrade parameter

Specifies to perform a version-to-version upgrade on the SPSite object. When this parameter is set, it internally triggers all available build-to-build actions that are associated with the current site collection operating mode. Version-to-version actions follow to bring site collections to the next site collection operating mode inclusive of all new build-to-build actions that are associated with the new site collection operating mode. When this parameter is not set, it triggers only available build-to-build upgrade actions that are associated with the current site collection operating mode.
reference https://technet.microsoft.com/  

On next post see how to upgrade Sharepoint site collection from  Site Settings page of site collection.

Migrate SharePoint 2010 classic-mode web applications to SharePoint 2013 classic-mode web applications

In my last org task - Upgrade of SharePoint Server to SharePoint 2013 from SharePoint 2007 version, I found that  SharePoint 2013 default authentication method for web application is Claim based authentication and Windows Classic authentication method is deprecated in SharePoint 2013 release.

In SharePoint 2013, complete the following procedure to create a classic-mode web application, then migrate an existing SharePoint 2010 classic-mode Web application to SharePoint 2013 and at last convert an existing SharePoint 2010 classic-mode web application to a SharePoint 2013 web application that uses claims-based authentication.

First we will create a web application using PowerShell command because we cannot create web application having classic based authentication using central administration.

New-SPWebApplication -name "MySiteClassicAuthApp" -Port 100 

-ApplicationPool "MySiteClassicAuthAppPool"

-ApplicationPoolAccount(Get-SPManagedAccount "Domain\account")

Attach an existing content database of SharePoint 2010 version to our new 2013 web application, which we have already added in SQL Server before that we have to Test Content Database using “Test contentDB” powershell command for successful mount of content database.

     Mount-SPContentDatabase "<ContentDb>" -DatabaseServer "<DbServer>" 

       -WebApplication http://SiteName

 

Now detach a content database which was created while creating site.

Dismount-SPContentDatabase "<ContentdBName>"

Convert your SharePoint 2013 classic-mode web application to claims-based authentication - 

  Convert-SPWebApplication -Identity <yourWebAppUrl> 

         -To Claims

         -RetainPermissions [ -Force]

Retain permission property used to retain exiting permissions.

Note:

• If you not used -AuthenticationMethod parameter while creating New classic based auth web application then also by default classic based auth web app will be created.
• Account which your using have sufficient permission to perform activity in SQL and SharePoint.
• Convert-SPWebApplication converts the web application to claims-based authentication. You have to verify that the users can access the web application after you have converted it.
• You must use the content database GUID in this command instead of using the content database name, in case of multiple content databases that have the same name.
• To retrieve the GUID of the content database, run the Get-SPContentDatabase PowerShell cmdlet with no arguments.
• The Dismount-SPContentDatabase  detaches the content database from the web application, but it does not delete the content database from SQL Server. After detached, you cannot delete it by using Windows PowerShell 3.0. You can only remove it by using SQL Server tools. If you want to delete the content database from SQL Server while you detach it, use the Remove-SPContentDatabase instead.

Reference: http://technet.microsoft.com

Users are unable to upload any SIZE document in Sharepoint site

Some time you have seen such problem in your organization
"unable to upload document in SharePoint document library".
This problem is generally related to SQL Server When there is not enough disk space for your Database and you can easily resolve it issue by adding extra space.
But some time you have enough disk space for your SharePoint Site in SQL SERVER and
still you  are  facing problem : "Unable to upload document" for any File size:  4mb, 50 mb or more...

It  happens due to heavy fragmentation on the drive in which your Sql Server database is exist.

      Resolution : you have to perform following steps  when you have sufficient space for DB and still not able to upload document.........

      

1    1. De-attach your Database from Sql Server. 

          Copy MDF and LDF file of your Database, For example you have your mdf file and ldf file in DRIVE: A,  and paste it to another location like DRIVE: B. 

          Now delete both files from original location (drive: a) and Now Paste both files back to Drive: A from   drive b.

2    

      2. Now Attached the Database.

       

      This action will resolve your issue.

Configuration of RSS Viewer Web Part in SharePoint 2010

In this article I am going to explain how to configure RSS Viewer WebPart in your Site.

1. choose Edit Page option from site ribbon.
2. Add a web part -> categories -> content roll up -> RSS Viewer
3. select option as you desire in "Add Web Part to" drop down list.

 4. Now Select "Open Tool Pane"

 

5. Fill RSS Feed URL. E.g: "http://rss.msnbc.msn.com/id/3032091/device/rss/rss.xml"

 6. Fill "Feed refresh time" and "Feed Limit" as you need. Click on Apply then O.K.

Your RSS viewer part is now enable in your page.

Note: If you face any error in your RSS Viewer. For E.g. :

Or "The requested RSS feed could not be displayed. Please verify the settings and url for this feed. If this problem persists, please contact your administrator."   Or   " Requested URL feed does not exit" Then

1. Add Proxy setting in your site Web.config File. 2. reset IIS.  3. Check LAN Setting in Internet Explorer->Tool->Inernet Options->connection->LAN settings ... Your issue will resolev, Enjoy RSS Fees :)

Transaction Log increasing very fast of sharepoint content database

Number of user some time face problem related to  Transaction log "increasing very soon".
I have also faced same problem with my firm production server. In my case transaction log of Intranet Database was increasing 4 GB every day. Solution and Step which I have done to reduce size of transaction log are mention below:

1. First run SQL query 
    

S       SELECT log_reuse_wait_desc,name  FROM  sys.database  

     

             

    2.  Run sql command by choosing your Database  DBCC OPENTRAN, you will get result

Message:

 

-if the log_reuse_wait_desc is replication (for you Database) then remove it

Run query to remove Replication : EXEC sp_removedbreplication YourDatabaseName

1.      Check recovery model. If it is full then change it to simple first. Command is

ALTER database <database name> set recovery simple

Then shrink the log file command is

dbcc shrinkfile (<file name>,0)

It will shrink your log file at the minimum level. Now you can change your recovery model from simple to full if required.

Now Size of Database is decrease by using above steps in my case..

Help taken from following Blog :

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/01/size-of-the-transaction-log-increasing-and-cannot-be-truncated-or-shrinked-due-to-snapshot-replication.aspx

CAUSE MAY BE: non-distributed LSN in the log 

Resolution Help in error like : Can't able to upload document in SharePoint document library .