Service | Microsoft Docs article | Related commit history on GitHub | Change details |
---|---|---|---|
SharePoint | Introduction | https://github.com/MicrosoftDocs/OfficeDocs-SharePoint/commits/public/SharePoint/SharePointOnline/introduction.md | Previously updated : 07/11/2018 Title: "Introduction to SharePoint and OneDrive" Last updated : 06/05/2023 + Title: Introduction to SharePoint and OneDrive in Microsoft 365 for administrators ms.assetid: d5089cdf-3fd2-4230-acbd-20ecda2f9bb8 description: "Learn about SharePoint and OneDrive in Microsoft 365, which are cloud-based services that help organizations share and manage content, and collaborate with others." -# Introduction to SharePoint and OneDrive in Microsoft 365 +# Introduction to SharePoint and OneDrive in Microsoft 365 for administrators SharePoint and OneDrive in Microsoft 365 are cloud-based services that help organizations share and manage content, knowledge, and applications to: |
SharePoint | Manage Site Collection Storage Limits | https://github.com/MicrosoftDocs/OfficeDocs-SharePoint/commits/public/SharePoint/SharePointOnline/manage-site-collection-storage-limits.md | Last updated 07/11/2018 Title: "Manage site storage limits" + Title: Manage site storage limits in SharePoint in Microsoft 365 f1.keywords: - CSH +ms.localizationpriority: medium - Strat_SP_admin - M365-collaboration ms.assetid: 77389c2c-8e7e-4b16-ab97-1c7103784b08 description: "In this article, you'll learn how to use the SharePoint admin center to manage the storage limits for sites in your organization." -# Manage site storage limits +# Manage site storage limits in SharePoint in Microsoft 365 -The amount of Microsoft SharePoint space your organization has is based on your number of licenses (see [SharePoint Limits](/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits)). If you're a Global Administrator in Microsoft 365, you can [Add storage space for your subscription](/office365/admin/subscriptions-and-billing/add-storage-space) if you run out. +The amount of SharePoint space your organization has is based on your number of licenses (see [SharePoint Limits](/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits)). If you're a Global Administrator in Microsoft 365, you can [Add storage space for your subscription](/office365/admin/subscriptions-and-billing/add-storage-space) if you run out. ## View the total and available storage space for your organization 1. Go to <a href="https://go.microsoft.com/fwlink/?linkid=2185220" target="_blank">**Active sites** in the SharePoint admin center</a>, and sign in with an account that has [admin permissions](./sharepoint-admin-role.md) for your organization. - >[!NOTE] - > If you have Office 365 operated by 21Vianet (China), [sign in to the Microsoft 365 admin center](https://go.microsoft.com/fwlink/p/?linkid=850627), then browse to the SharePoint admin center and open the Active sites page. - 2. In the upper right of the page, see the amount of storage available and the total storage for your subscription. (If your organization has configured Multi-Geo in Microsoft 365, you can point to the bar to see the amount of storage used in the current geo location and all other geo locations.)  If you prefer to fine-tune the storage space allocated to each site, you can set 1. Go to <a href="https://go.microsoft.com/fwlink/?linkid=2185072" target="_blank">**Settings** in the SharePoint admin center</a>, and sign in with an account that has [admin permissions](./sharepoint-admin-role.md) for your organization. - > [!NOTE] - > If you have Office 365 operated by 21Vianet (China), [sign in to the Microsoft 365 admin center](https://go.microsoft.com/fwlink/p/?linkid=850627), then browse to the SharePoint admin center and open the Settings page. - 2. Select **Site storage limits**.  Follow these steps to specify individual site storage limits when your storage m 1. Go to <a href="https://go.microsoft.com/fwlink/?linkid=2185220" target="_blank">**Active sites** in the SharePoint admin center</a>, and sign in with an account that has [admin permissions](./sharepoint-admin-role.md) for your organization. - >[!NOTE] - > If you have Office 365 operated by 21Vianet (China), [sign in to the Microsoft 365 admin center](https://go.microsoft.com/fwlink/p/?linkid=850627), then browse to the SharePoint admin center and open the Active sites page. - 2. In the left column, select the site, or for a channel site, select the link in the **Channel sites** column. 3. Select **Storage** on the command bar to open edit storage limit panel. Follow these steps to specify individual site storage limits when your storage m > [!NOTE] > The max value you can enter is 25600 GB, although this may be more space than your organization has. To learn how your total storage is calculated, see [SharePoint Limits](/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits).- > - > If you set site storage limits in PowerShell, you enter them in MB. The values are converted and rounded down to the nearest integer to appear in GB in both the SharePoint admin center. So a value of 5000 MB becomes 4 GB. The minimum storage limit is 1 GB, so if you set a value of less than 1024 MB by using PowerShell, it will be rounded up to 1 GB. 5. Make sure **Notifications** is turned on to send an email to site admins when the site approaches the storage limit. Then, enter a value as a percent for how full you want the storage to be when the email is sent. If a site runs out of storage, site admins can request more by following these s 3. Select **Request more quota** in the upper right. This sends a storage request email to the Global Administrators in the organization.-- - -### Monitor site storage limits by using PowerShell --If you manage storage limits manually, you need to regularly monitor them to make sure they aren't affecting site performance. We recommend that you also set up your own alert emails to notify site admins before a site reaches the limit. The built-in storage quota warning emails are typically sent weekly for sites that have reached the specified warning level. So site admins often receive the storage quota warning email too late. For example, if the Disk Quota Warning timer job (which triggers the warning email) is scheduled weekly and sends the email warning every Sunday, but a site reaches the quota warning limit on Monday, the site admin doesn't receive the alert email for six days. This site could reach the maximum storage limit and be set to read-only before the site admin receives the alert email. - -You can use the following Microsoft PowerShell script to monitor your sites. This script pulls the data, composes, and then sends a storage warning alerts to the site admin. - -1. [Download the latest SharePoint Online Management Shell](https://go.microsoft.com/fwlink/p/?LinkId=255251). -- > [!NOTE] - > If you installed a previous version of the SharePoint Online Management Shell, go to Add or remove programs and uninstall "SharePoint Online Management Shell." --2. Connect to SharePoint as a [Global Administrator or SharePoint Administrator](./sharepoint-admin-role.md) in Microsoft 365. To learn how, see [Getting started with SharePoint Online Management Shell](/powershell/sharepoint/sharepoint-online/connect-sharepoint-online). - -3. Copy the following text with the variable declarations, and paste it into a text editor, such as Notepad. You must set all of the input values to be specific to your organization. Save the file, and then rename it "GetEmailWarning.ps1". - - > [!NOTE] - > You can use a different file name, but you must save the file as an ANSI-encoded text file with the extension .ps1. - - ```powershell - #Connect to SharePoint admin center using an admin account - #Specify the URL to your SharePoint admin center site, e.g. https://contoso-admin.sharepoint.com - - $url = 'https://contoso-admin.sharepoint.com' - - #Specify a folder path to output the results into - $path = '.\' - - #SMTP details - $Smtp = '<SmtpServer>' - $From = '<SenderEmailAddress>' - $To = '<RecipientEmailAddress>' - $Subject = 'Site Storage Warning' - $Body = 'Storage Usage Details' - - if($url -eq '') { - $url = Read-Host -Prompt 'Enter the SharePoint admin center URL' - } - - Connect-SPOService -Url $url - - #Local variable to create and store output file - $filename = (Get-Date -Format o | foreach {$_ -Replace ":", ""})+'.csv' - $fullpath = $path+$filename - - #Enumerating all sites and calculating storage usage - $sites = Get-SPOSite - $results = @() - - foreach ($site in $sites) { - $siteStorage = New-Object PSObject - - $percent = $site.StorageUsageCurrent / $site.StorageQuota * 100 - $percentage = [math]::Round($percent,2) - - $siteStorage | Add-Member -MemberType NoteProperty -Name "Site Title" -Value $site.Title - $siteStorage | Add-Member -MemberType NoteProperty -Name "Site Url" -Value $site.Url - $siteStorage | Add-Member -MemberType NoteProperty -Name "Percentage Used" -Value $percentage - $siteStorage | Add-Member -MemberType NoteProperty -Name "Storage Used (MB)" -Value $site.StorageUsageCurrent - $siteStorage | Add-Member -MemberType NoteProperty -Name "Storage Quota (MB)" -Value $site.StorageQuota - - $results += $siteStorage - $siteStorage = $null - } - - $results | Export-Csv -Path $fullpath -NoTypeInformation - - #Sending email with output file as attachment - Send-MailMessage -SmtpServer $Smtp -To $To -From $From -Subject $Subject -Attachments $fullpath -Body $Body -Priority high - ``` --4. Where: -- - **$url** is the URL of your SharePoint admin center. If the `$url` variable is left empty, you will be prompted to enter the URL of your admin center site. - - - **$path** is the file system path you want the CSV file to output to. - - - **\<SmtpServer\>** is the name of your mail server. - - - **\<SenderEmailAddress\>** is the Global Administrator or SharePoint Administrator account that appears in the From line in the warning email. - - - **\<RecipientEmailAddress\>** is the admin account that will receive the email warning. - -5. In SharePoint Online Management Shell, change to the local directory where you saved the script file. - - ``` - ./GetEmailWarning.ps1 - ``` --After the script successfully completes, a text file is created in the location that you specified in the **$path** variable in the script. --> [!NOTE] -> If you get an error message about being unable to run scripts, you might need to change your execution policies. For info, see [About Execution Policies](/powershell/module/microsoft.powershell.core/about/about_execution_policies). - |
SharePoint | Turn External Sharing On Or Off | https://github.com/MicrosoftDocs/OfficeDocs-SharePoint/commits/public/SharePoint/SharePointOnline/turn-external-sharing-on-or-off.md | Previously updated : 07/11/2018 Title: "Manage sharing settings" Last updated : 06/06/2023 + Title: Manage sharing settings for SharePoint and OneDrive in Microsoft 365 search.appverid: - SPO160 - MET150 ms.assetid: 6288296a-b6b7-4ea4-b4ed-c297bf833e30-description: "Learn how global and SharePoint admins can change the organization-level sharing settings for SharePoint and OneDrive in Microsoft 365." +description: "Learn how global and SharePoint administrators can change the organization-level sharing settings for SharePoint and OneDrive in Microsoft 365." -# Manage sharing settings +# Manage sharing settings for SharePoint and OneDrive in Microsoft 365 -This article describes how Global Administrators and SharePoint Administrators in Microsoft 365 can change their organization-level sharing settings for Microsoft SharePoint and Microsoft OneDrive. (If you want to share a file or folder, read [Share SharePoint files or folders](https://support.office.com/article/1fe37332-0f9a-4719-970e-d2578da4941c) or [Share OneDrive files and folders](https://support.office.com/article/9fcc2f7d-de0c-4cec-93b0-a82024800c07).) +This article describes how global administrators and SharePoint administrators in Microsoft 365 can change their organization-level sharing settings for SharePoint and OneDrive. (If you want to share a file or folder, read [Share SharePoint files or folders](https://support.office.com/article/1fe37332-0f9a-4719-970e-d2578da4941c) or [Share OneDrive files and folders](https://support.office.com/article/9fcc2f7d-de0c-4cec-93b0-a82024800c07).) For end-to-end guidance around how to configure guest sharing in Microsoft 365, see: - [Set up secure collaboration with Microsoft 365](/microsoft-365/solutions/setup-secure-collaboration-with-teams) For end-to-end guidance around how to configure guest sharing in Microsoft 365, - [Collaborate with guests in a site](/microsoft-365/solutions/collaborate-in-site) - [Collaborate with guests in a team](/microsoft-365/solutions/collaborate-as-team) -To change the sharing settings for a site after you've set the organization-level sharing settings, see [Change sharing settings for a site](change-external-sharing-site.md). To learn how to change the external sharing setting for a user's OneDrive, see [Change the external sharing setting for a user's OneDrive](/onedrive/user-external-sharing-settings). +To change the sharing settings for a site after you've set the organization-level sharing settings, see [Change sharing settings for a site](change-external-sharing-site.md). To learn how to change the external sharing setting for a specific user's OneDrive, see [Change the external sharing setting for a user's OneDrive](/onedrive/user-external-sharing-settings). ## Video demonstration This video shows how the settings on the <a href="https://go.microsoft.com/fwlin 1. Go to <a href="https://go.microsoft.com/fwlink/?linkid=2185222" target="_blank">**Sharing** in the SharePoint admin center</a>, and sign in with an account that has [admin permissions](./sharepoint-admin-role.md) for your organization. -2. Under **External sharing**, specify your sharing level for SharePoint and OneDrive. The default level for both is "Anyone." +2. Under **External sharing**, specify your sharing level for SharePoint and OneDrive. The default level for both is **Anyone**. > [!NOTE]- > The SharePoint setting applies to all site types, including those connected to Microsoft 365 groups. + > The SharePoint setting applies to all site types, including those connected to Microsoft 365 groups and teams. > > The OneDrive setting can be more restrictive than the SharePoint setting, but not more permissive. This video shows how the settings on the <a href="https://go.microsoft.com/fwlin | Select this option: | If you want to: | |:--|:--| |**Anyone** <br/> | Allow users to share files and folders by using links that let anyone who has the link access the files or folders without authenticating. This setting also allows users to share sites with new and existing guests who authenticate. If you select this setting, you can restrict the Anyone links so that they must expire within a specific number of days, or so that they can give only View permission.<br/><br/>[File requests](https://support.office.com/article/f54aa7f8-2589-4421-b351-d415fc3b83af) requires that OneDrive be set to **Anyone** and edit permissions for **Anyone** links be enabled. OneDrive settings other than **Anyone** disable file requests.<br/><br/>See [Best practices for sharing files and folders with unauthenticated users](/Office365/Enterprise/best-practices-anonymous-sharing) for more information.<br/>|-|**New and existing guests** <br/> | Require people who have received invitations to sign in with their work or school account (if their organization uses Microsoft 365) or a Microsoft account, or to provide a code to verify their identity. Users can share with guests already in your organization's directory, and they can send invitations to people who will be added to the directory if they sign in. For more info about verification codes, see [Secure external sharing in SharePoint](what-s-new-in-sharing-in-targeted-release.md)<br/><br/>Invitations to view content can be redeemed only once. After an invitation has been accepted, it can't be shared or used by others to gain access. <br/> | +|**New and existing guests** <br/> | Require people who have received invitations to sign in with their work or school account (if their organization uses Microsoft 365) or a Microsoft account, or to provide a code to verify their identity. Users can share with guests already in your organization's directory, and they can send invitations to people who will be added to the directory if they sign in. For more info about verification codes, see [Secure external sharing in SharePoint](what-s-new-in-sharing-in-targeted-release.md) | |**Existing guests** <br/> |Allow sharing only with guests who are already in your directory. These guests may exist in your directory because they previously accepted sharing invitations or because they were manually added, such as through [Azure B2B collaboration](/azure/active-directory/b2b/what-is-b2b). (To see the guests in your organization, go to the [Guests page in the Microsoft 365 admin center](https://admin.microsoft.com/Adminportal/Home#/GuestUsers)). <br/> | |**Only people in your organization** <br/> | Turn off external sharing. If your administrator has set an expiration time for guest access, each guest th **People who use a verification code must reauthenticate after this many days** -If people who use a verification code have selected to "stay signed in" in the browser, they must prove they can still access the account they used to redeem the sharing invitation. +If people who use a verification code have selected to "stay signed in" in the browser, they must prove they can still access the account they used to redeem the sharing invitation by entering a code sent to that account. ## File and folder links -Choose the option you want to show by default when a user gets a link. +Choose the option you want to show by default when a user creates a sharing link.  > [!NOTE]-> This setting specifies the default for your organization, but site owners can choose a different default link type for a site. +> This setting specifies the default for your organization, but you can choose a different default link type for a site. - **Specific people** - This option is most restrictive and impedes broad internal sharing. If you allow external sharing, this option lets users share with specific people outside the organization. - **Only people in your organization** - If links are forwarded, they'll work for anyone in the organization. This option is best if your organization shares broadly internally and rarely shares externally. -- **Anyone with the link** - This option is available only if your external sharing setting is set to "Anyone." Forwarded links work internally or externally, but you can't track who has access to shared items or who has accessed shared items. This is best for friction-free sharing if most files and folders in SharePoint and OneDrive aren't sensitive. +- **Anyone with the link** - This option is available only if your external sharing setting is set to **Anyone**. Forwarded links work internally or externally, but you can't track who has access to shared items or who has accessed shared items. This is best for friction-free sharing if most files and folders in SharePoint and OneDrive aren't sensitive. > [!IMPORTANT]- > If you select "Anyone with the link," but the site or OneDrive is set to allow sharing only with guests who sign in or provide a verification code, the default link is "Only people in your organization." Users need to change the link type to "Specific people" to share files and folders in the site or OneDrive externally. + > If you select **Anyone with the link**, but the site or OneDrive is set to allow sharing only with guests who sign in or provide a verification code, the default link is **Only people in your organization**. Users need to change the link type to **Specific people** to share files and folders in the site or OneDrive externally. -### Advanced settings for "Anyone" links +### Advanced settings for **Anyone** links  -**Link expiration** - You can require all "Anyone" links to expire, and specify the maximum number of days allowed. If you change the expiration time, existing links will keep their current expiration time if the new setting is longer, or be updated to the new setting if the new setting is shorter. +**Link expiration** - You can require all **Anyone** links to expire, and specify the maximum number of days allowed. If you change the expiration time, existing links will keep their current expiration time if the new setting is longer, or be updated to the new setting if the new setting is shorter. -**Link permissions** - You can restrict "Anyone" links so that they can only provide view permission for files or folders. +**Link permissions** - You can restrict **Anyone** links so that they can only provide view permission for files or folders. If you are using file requests, the link permissions must be set for **View and edit** for files and **View, edit, and upload** for folders. -## Other +## Other settings  -**Display to owners the names of people who viewed their files** +**Show owners the names of people who viewed their files in OneDrive** This setting lets you control whether the owner of a shared file can see on the file card the people who only view (and don't edit) the file in OneDrive. The file card appears when users hover over a file name or thumbnail in OneDrive. The info includes the number of views on the file, the number of people who viewed it, and the list of people who viewed it. To learn more about the file card, see [See files you shared in OneDrive](https://support.office.com/article/6b67b82b-9c5c-4348-ab10-fd5b0d8df76c). This setting is turned on by default at the organization level and off at the si > [!NOTE] > Historical data is included when this setting is enabled. Likewise, if the setting is turned off and back on at the organization level or site level, the views during the off period are included in the history. -On the classic Sharing page, you can limit external sharing by security group and shorten sharing links or change their default permission. +**Use short links for sharing files and folders** ++Uses a shorter link format for sharing files and folders. This may be useful if you have integrations that require a shorter URL. ## Need more help? You can also find help on security and permissions in these [YouTube videos from [Stop sharing files or folders or change permissions](https://support.office.com/article/0a36470f-d7fe-40a0-bd74-0ac6c1e13323) -[External sharing & collaboration with OneDrive, SharePoint & Teams (Ignite 2020)](https://www.youtube.com/watch?v=9VBbRQNDUD8) - |
SharePoint | Deploy Azure Sql Managed Instance With Sharepoint Servers | https://github.com/MicrosoftDocs/OfficeDocs-SharePoint/commits/public/SharePoint/SharePointServer/administration/deploy-azure-sql-managed-instance-with-sharepoint-servers.md | + Last updated : 05/20/2019 + Title: "Deploy SharePoint Server with Azure SQL Managed Instance" +++++ms.audience: ITPro +f1.keywords: +- NOCSH +++ms.localizationpriority: medium ++- IT_Sharepoint_Server +- IT_Sharepoint_Server_Top +- Strat_SP_server ++description: "Learn how to deploy SharePoint Servers 2016, 2019, and Subscription Edition with Azure SQL Managed Instance (MI)." +++# Deploy SharePoint Server with Azure SQL Managed Instance +++SharePoint Server 2016, SharePoint Server 2019, and SharePoint Server Subscription Edition support Azure SQL Managed Instance (MI). SQL MI is a deployment option of Azure SQL Database and is compatible with the current version of SQL Server (on-premises), Enterprise Edition Database Engine. ++> [!IMPORTANT] +> SharePoint Server farms must be hosted in Microsoft Azure to support Azure SQL Managed Instance. The SharePoint Server farm and the managed instance must be hosted in the same Azure region. SharePoint Server farms don't support managed instances when hosted in customer data centers. ++Deploying SharePoint Server with an Azure SQL Managed Instance lets you move your SQL Server on-premises application to the cloud with little or no application and database changes. The following procedure shows how to deploy SharePoint Servers 2016, 2019, or Subscription Edition with an Azure SQL Managed Instance. +++## Environment ++1. Create a resource group with a vNet and then create two subnets. You can use the [SQL Managed Instance Virtual Network Environment](https://github.com/Azure/azure-quickstart-templates/tree/master/quickstarts/microsoft.sql/sql-managed-instance-azure-environment) template to create an Azure Virtual Network with two subnets. + +2. Create subnet 1 (Default) and then create two VMs. First, set up VM 1 as an Active Directory Directory Services domain controller and configure your domain. For more information, see [Step-By-Step: Setting up Active Directory in Windows Server 2016](/archive/blogs/canitpro/step-by-step-setting-up-active-directory-in-windows-server-2016). ++3. Install SharePoint Server 2016 or SharePoint Server 2019 or SharePoint Server Subscription Edition in VM 2: + + 1. Run **`PrerequitsiteInstaller.exe`**. + + 2. Run **`Setup.exe`**. + + 3. If you're using SharePoint Server 2016 or SharePoint Server 2019, install the May 2019 (or newer) sts core patch for SharePoint Server 2016 ([KB 4464549](https://support.microsoft.com/help/4464549)) or for SharePoint Server 2019 ([KB 4464556](https://support.microsoft.com/help/4464556)). + + 4. If you're using SharePoint Server 2016 or SharePoint Server 2019, Install the April 2019 (or newer) wssloc MUI/language pack patch for SharePoint Server 2016 ([KB 4461507](https://support.microsoft.com/help/4461507)) or for SharePoint Server 2019 ([KB 4462221](https://support.microsoft.com/help/4462221)). ++ > [!NOTE] + > You can join other VMs to Active Directory in subnet 1. + > + > No updates need to be installed for SharePoint Server Subscription Edition. ++3. Create an Azure SQL Managed Instance in subnet 2, within this resource group (ManagedInstance). ++ > [!IMPORTANT] + > No other resources can reside in subnet 2 except for SQL MI. + ++4. Create or join the SharePoint farm, hosting the databases on SQL MI with SQL authentication. ++ 1. To create the SharePoint farm, open the **SharePoint Management Shell** and run the following Windows PowerShell commands: ++ ```powershell + $FarmCredential = Get-Credential -Message "Provide the user name and password for the SharePoint farm service account." + $DBCredential = Get-Credential -Message "Provide the user name and password for the Azure SQL Managed Instance database login." + $FarmPassphrase = Read-Host -AsSecureString -Prompt "Provide the SharePoint farm passphrase" ++ New-SPConfigurationDatabase -DatabaseServer <DBServer> -DatabaseName <ConfigDB> -FarmCredentials $FarmCredential -DatabaseCredentials $DBCredential -Passphrase $FarmPassphrase -LocalServerRole <ServerRole> + ``` ++ 2. To join additional VMs to the SharePoint farm, open the **SharePoint Management Shell** on the additional VMs and run the following Windows PowerShell commands: + + ```powershell + $DBCredential = Get-Credential -Message "Provide the user name and password for the Azure SQL Managed Instance database login." + $FarmPassphrase = Read-Host -AsSecureString -Prompt "Provide the SharePoint farm passphrase" ++ Connect-SPConfigurationDatabase -DatabaseServer <DBServer> -DatabaseName <ConfigDB> -DatabaseCredentials $DBCredential -Passphrase $FarmPassphrase -LocalServerRole <ServerRole> + ``` ++ Where: + + - _\<DBServer\>_ is the name you gave the Azure SQL Managed Instance in step 4. + - _\<ConfigDB\>_ is the name of the SharePoint configuration database to be created. + - _\<ServerRole\>_ is the SharePoint MinRole server role for this server in the SharePoint farm. ++5. Run the **SharePoint Products Configuration Wizard** to complete the configuration. Next open Central Administration to complete the **Farm Configuration Wizard**. ++> [!NOTE] +> SharePoint Server doesn't support connecting to databases hosted in Azure SQL Managed Instance using Windows authentication. ++> [!NOTE] +> Access Services isn't supported with Azure SQL Managed Instance. +++## See also +<a name="proc1"> </a> ++#### Other Resources ++[Azure SQL Database managed instance](/azure/sql-database/sql-database-managed-instance-index) ++[SQL Server instance migration to Azure SQL Database managed instance](/azure/sql-database/sql-database-managed-instance-migrate) ++[Quickstart: Create an Azure SQL Database managed instance](/azure/sql-database/sql-database-managed-instance-get-started) ++[Quickstart: Configure Azure VM to connect to an Azure SQL Database Managed Instance](/azure/sql-database/sql-database-managed-instance-configure-vm) ++[Quickstart: Restore a database to a Managed Instance](/azure/sql-database/sql-database-managed-instance-get-started-restore) |
SharePoint | Sql Server And Storage | https://github.com/MicrosoftDocs/OfficeDocs-SharePoint/commits/public/SharePoint/SharePointServer/administration/sql-server-and-storage.md | description: "Learn how to plan for SQL Server and storage configuration for Sha The following articles provide information about SQL Server and storage configuration for SharePoint Server. -|**  Content**|**Description**| +|  Content|**Description**| |:--|:--| |[Overview of SQL Server in SharePoint Server 2016 and 2019 environments](overview-of-sql-server-in-sharepoint-server-2016-and-2019-environments.md) <br/> |Describes the relationship between SharePoint Servers 2016 and 2019, the supported versions of SQL Server and how you can interact with the databases. <br/> | |[Overview of SQL Server in a SharePoint Server 2013 environment](overview-of-sql-server-in-a-sharepoint-server-2013-environment.md) <br/> |Describes the relationship between SharePoint Server 2013 and supported versions of SQL Server and how you can interact with the databases. <br/> |-|[Deploy Azure SQL Managed Instance with SharePoint Server 2016 and 2019](../administration/deploy-azure-sql-managed-instance-with-sharepoint-servers-2016-2019.md) <br/> |Describes how to deploy Azure SQL Managed Instance with SharePoint Servers 2016 and 2019 that are hosted in Microsoft Azure. <br/> | +|[Deploy SharePoint Server with Azure SQL Managed Instance](../administration/deploy-azure-sql-managed-instance-with-sharepoint-servers.md) <br/> |Describes how to deploy SharePoint Servers 2016, 2019, and Subscription Edition that are hosted in Microsoft Azure with Azure SQL Managed Instance. <br/> | |[Storage and SQL Server capacity planning and configuration (SharePoint Server)](storage-and-sql-server-capacity-planning-and-configuration.md) <br/> |Describes a process for planning storage and SQL Server capacity for a SharePoint Server deployment. <br/> | |
SharePoint | Installing Sharepoint Server Subscription Edition On Windows Server Core | https://github.com/MicrosoftDocs/OfficeDocs-SharePoint/commits/public/SharePoint/SharePointServer/install/installing-sharepoint-server-subscription-edition-on-windows-server-core.md | Perform the following steps to install SharePoint Server Subscription Edition on 11. Run the following SharePoint PowerShell cmdlets with their appropriate parameters to create or join a farm. 1. `New-SPConfigurationDatabase` to create a farm or `Connect-SPConfigurationDatabase` to join a farm.- 2. `Install-SPHelpCollection -All` - 3. `Initialize-SPResourceSecurity` - 4. `Install-SPService` - 5. `Install-SPFeature -AllExistingFeatures` - 6. `New-SPCentralAdministration` - 7. `Install-SPApplicationContent` + 2. `Update-SPFlightsConfigFile -FilePath "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\CONFIG\SPFlightRawConfig.json"` + 3. `Install-SPHelpCollection -All` + 4. `Initialize-SPResourceSecurity` + 5. `Install-SPService` + 6. `Install-SPFeature -AllExistingFeatures` + 7. `New-SPCentralAdministration` + 8. `Install-SPApplicationContent` > [!Note] > You can also use the `PSCONFIG.EXE` command line tool or the `PSConfigUI.exe` GUI tool. However, `PSConfigUI.exe` will crash on Windows Server Core if it needs to display a summary of error messages at the end of the sequence due to a dependency on HTML rendering components. |
SharePoint | Repair Sharepoint Server Subscription Edition | https://github.com/MicrosoftDocs/OfficeDocs-SharePoint/commits/public/SharePoint/SharePointServer/install/repair-sharepoint-server-subscription-edition.md | SharePoint Server repair steps are as follows: 3. Run the following SharePoint PowerShell cmdlets with their appropriate parameters to repair the server in the farm. - 1. `Install-SPHelpCollection -All` - 2. `Initialize-SPResourceSecurity` - 3. `Install-SPService` - 4. `Install-SPFeature -AllExistingFeatures` - 5. `New-SPCentralAdministration` (If hosting the Central Administration site on this server) - 6. `Install-SPApplicationContent` + 1. `Update-SPFlightsConfigFile -FilePath "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\CONFIG\SPFlightRawConfig.json"` + 2. `Install-SPHelpCollection -All` + 3. `Initialize-SPResourceSecurity` + 4. `Install-SPService` + 5. `Install-SPFeature -AllExistingFeatures` + 6. `New-SPCentralAdministration` (If hosting the Central Administration site on this server) + 7. `Install-SPApplicationContent` > [!Note] > You can also use the `PSCONFIG.EXE` command line tool or the `PSConfigUI.exe` GUI tool. However, `PSConfigUI.exe` will crash on Windows Server Core if it needs to display a summary of error messages at the end of the sequence due to a dependency on HTML rendering components. |
SharePoint | Software Requirements For Database Servers For Sharepoint Server Subscription Edition | https://github.com/MicrosoftDocs/OfficeDocs-SharePoint/commits/public/SharePoint/SharePointServer/install/software-requirements-for-database-servers-for-sharepoint-server-subscription-edition.md | SharePoint Server Subscription Edition supports the following database versions: - A Standard or Enterprise Edition of SQL Server for Windows that supports database compatibility level 150. This includes SQL Server 2019 Cumulative Update 5 (CU5) or later, SQL Server 2022, and any future version of SQL Server for Windows that supports database compatibility level 150. For more information about database compatibility levels, see [Compatibility Certification](/sql/database-engine/install-windows/compatibility-certification) and [ALTER DATABASE (Transact-SQL) Compatibility Level](/sql/t-sql/statements/alter-database-transact-sql-compatibility-level). -- Microsoft Azure SQL Managed Instance (MI). This is only supported if your SharePoint Server farm is hosted in Microsoft Azure. For more information, see [Deploy Azure SQL Managed Instance with SharePoint Servers 2016 and 2019](/sharepoint/administration/deploy-azure-sql-managed-instance-with-sharepoint-servers-2016-2019).+- Microsoft Azure SQL Managed Instance (MI). This is only supported if your SharePoint Server farm is hosted in Microsoft Azure. For more information, see [Deploy SharePoint Server with Azure SQL Managed Instance](/sharepoint/administration/deploy-azure-sql-managed-instance-with-sharepoint-servers). > [!NOTE] > SQL Server products and all future SQL Server Cumulative Updates are supported through the SQL Server product lifecycle. |