Database is in compatibility range and upgrade is recommended

Source: http://www.justanothertechnologyguy.com/2011/11/databases-require-upgrade-or-not.html

Upgrading Content databases using SharePoint 2010 Management Shell

  • Start the “SharePoint 2010 Management Shell”
  • In the Shell enter : Get-SPContentDatabase –site [url towards your site collection]
  • Cut and paste the GUID to the following command:Upgrade-SPContentDatabase [guid]

It will take some time before the 100% appears.

Upgrading ‘all other’ type of databases using psconfig.exe

  • Open a command box in ‘run as administrator’ mode.
  • Navigate to the bin directory of the SharePoint root. C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
  • Run the following command: PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures
The PSConfig.exe tool will go though several steps to upgrade all the databases in the correct sequence.
Validate that all the databases where updated successfully.
  • Open “Central Administration”.
  • Click “Upgrade and Migration”
  • Click “Review Database Status”
    When the process is complete all of the databases should say ‘no action required’

    Comments

    Post a Comment

    Popular posts from this blog

    Configure SharePoint Server to use Office Online Server

    In a test environment that uses HTTP ======================================================================== Step 1: Create the binding between SharePoint 2016 and Office Web Apps Server New-SPWOPIBinding -ServerName <WacServerName> -AllowHTTP Step 2: View the WOPI zones for the SharePoint bindings Get-SPWOPIZone Step 3: Change the WOPI zone to internal-http Set-SPWOPIZone -zone "internal-http" Step 4: Change the AllowOAuthOverHttp setting in SharePoint 2016 to True (Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp $config = (Get-SPSecurityTokenServiceConfig) $config.AllowOAuthOverHttp = $true $config.Update() (Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp Step 5: Enable the Excel SOAP API $Farm = Get-SPFarm $Farm.Properties.Add("WopiLegacySoapSupport", "<URL>/x/_vti_bin/ExcelServiceInternal.asmx"); $Farm.Update(); Step 6: Verify that Office Web Apps is working In a production environment that uses H...
    Read more

    PowerShell command to import Module and Get-ADUser

    PS C:\Users\adm_shahidul> Get-Module -ListAvailable     Directory: C:\Windows\system32\WindowsPowerShell\v1.0\Modules ModuleType Version    Name                                ExportedCommands ---------- -------    ----                                ---------------- Manifest   2.0.0.0    AppLocker                           {Get-AppLockerFile... Manifest   2.0.0.0    Appx                                {Add-AppxPackage, ... Manifest   1.0        BestPractices                       {Get-BpaModel, Get... Manifest   1.0.0.0   ...
    Read more

    Configure Office Web Apps for SharePoint 2013

    copied from: https://technet.microsoft.com/en-us/library/ff431687.aspx Configure SharePoint 2013 to use Office Web Apps Server Choose one of the following sections depending on whether you want to use HTTP or HTTPS. HTTP is generally recommended only for test environments. In production environments, the more secure HTTPS protocol is the better choice. In a test environment that uses HTTP For this configuration, make sure you have set up Office Web Apps Server by following the steps in  Deploy a single-server Office Web Apps Server farm in a test environment . Be sure to configure the Office Web Apps Server farm to use an internal URL and HTTP. The Video: Configure Office Web Apps for SharePoint 2013  shows how to set up Office Web Apps Server and configure SharePoint 2013 to use Office Web Apps Server in a test environment. Step 1: Open an elevated SharePoint 2013 Management Shell Choose the procedure that corresponds to your server operatin...
    Read more