Possibity of upgrade and migration from SQL 2014 to SQL 2022

<!DOCTYPE html> <html class="layout layout-sidecar-right default-focus" lang="en-us" dir="ltr" data-authenticated="false" data-auth-status-determined="false" data-target="docs" x-ms-format-detection="none" > <head> <title>Possibity of upgrade and migration from SQL 2014 to SQL 2022 - Microsoft Q&A</title> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta name="color-scheme" content="light dark" /> <meta name="title" content="Possibity of upgrade and migration from SQL 2014 to SQL 2022 - Microsoft Q&A" /> <meta name="description" content="HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards," /> <link rel="canonical" href="https://learn.microsoft.com/en-us/answers/questions/2119458/possibity-of-upgrade-and-migration-from-sql-2014-t" />  <meta name="twitter:card" content="summary_large_image" /> <meta name="twitter:site" content="@MicrosoftLearn" /> <meta property="og:type" content="website" /> <meta property="og:image:alt" content="Microsoft Learn" /> <meta property="og:image" content="https://learn.microsoft.com/en-us/media/open-graph-image.png" />  <meta property="og:title" content="Possibity of upgrade and migration from SQL 2014 to SQL 2022 - Microsoft Q&A" /> <meta property="og:url" content="https://learn.microsoft.com/en-us/answers/questions/2119458/possibity-of-upgrade-and-migration-from-sql-2014-t" /> <meta property="og:description" content="HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards," /> <meta name="locale" content="en-us" /> <meta name="uhfHeaderId" content="answersv2" /> <meta name="pageType" content="QnA" />  <meta name="robots" content="all" />  <meta name="authorId" content="8bc1fa1a-80bc-4765-a605-d580afc94b00" /> <meta name="createdAt" content="2024-11-15T08:49:17.6066667+00:00" /> <meta name="updatedAt" content="2024-11-22T14:37:11.7166667+00:00" /> <meta name="pageCount" content="1" /> <meta name="tag" content="https://authoring-docs-microsoft.poolparty.biz/devrel/ced846cc-6a3c-4c8f-9dfb-3de0e90e2742" /> <meta name="tag" content="https://microsoft-devrel.poolparty.biz/DevRelOfferingOntology/d3ae2f60-cbb1-462c-89e2-5e4044271d61" /> <meta name="questionId" content="2119458" /> <meta name="search.isTopContent" content="false" />  <link rel="stylesheet" href="/static/assets/0.4.029666293/styles/site-ltr.css" /> <script src="https://wcpstatic.microsoft.com/mscc/lib/v2/wcp-consent.js"></script> <script src="https://js.monitor.azure.com/scripts/c/ms.jsll-4.min.js"></script> <script src="/_themes/docs.theme/master/en-us/_themes/global/deprecation.js"></script>  <script id="msdocs-script"> var msDocs = { "environment": { "accessLevel": "online", "azurePortalHostname": "portal.azure.com", "reviewFeatures": false, "supportLevel": "production", "systemContent": true, "siteName": "learn", "legacyHosting": false }, "data": { "contentLocale": "en-us", "contentDir": "ltr", "userLocale": "en-us", "userDir": "ltr", "pageTemplate": "Question", "brand": "docs", "context": {}, "hasBinaryRating": false, "showFeedbackReport": false, "enableTutorialFeedback": false, "contentGitUrl": "", "extendBreadcrumb": false, "isEditDisplayable": false, "hideViewSource": false, "hasPageActions": false, "hasBookmark": true, "isPermissioned": false, "hasShare": true, "hasRecommendations": true, "openSourceFeedback": false, "contributors": [] }, "functions": {} };; </script>  <script src="/static/assets/0.4.029666293/scripts/en-us/index-critical-qna.js"></script> <script defer src="/static/assets/0.4.029666293/scripts/en-us/index-qna.js"></script>  <script type="application/ld+json"> {"@context":"https://schema.org","@type":"QAPage","mainEntity":{"@type":"Question","id":2119458,"name":"Possibity of upgrade and migration from SQL 2014 to SQL 2022","text":"\u003cp\u003eHI Team,\u003c/p\u003e\n\u003cp\u003eI am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way.\u003c/p\u003e\n\u003cp\u003eKind regards,\u003c/p\u003e","answerCount":2,"upvoteCount":0,"author":"Tarik sendro","authorId":"8bc1fa1a-80bc-4765-a605-d580afc94b00","acceptedAnswer":[],"suggestedAnswer":[{"@type":"Answer","id":1877230,"text":"\u003cp\u003eI assume that you have SQL 2014 Standard Edition. Can you share the output of SELECT @@version?\u003c/p\u003e\n\u003cp\u003eIt is certainly possible, but as for what is the easiest way, that depends on the situation.\u003c/p\u003e\n\u003cp\u003eIn many cases when you move to a new version of SQL Server, you also migrate to new hardware, not the least when the leap is this big. An important factor here is also the operating system. What OS do you have? If you have a really old OS, it may not be supported by SQL 2022. Which is one more reason to move to new hardware.\u003c/p\u003e\n\u003cp\u003eAlso, is this is a physical machine or virtual machine? Virtual machines permits you to clone or snapshot them and run a test upgrade. With a physical machine, you need to cross Rubicon directly. (Since you specify the hardware specs, I assume that it is physical.)\u003c/p\u003e\n\u003cp\u003eIf you want to keep the hardware, and the OS is Window Server 2016 or later, you can run an in-place upgrade. This is a supported \u003ca href=\"https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16\" rel=\"ugc nofollow\"\u003eversion upgrade\u003c/a\u003e.\u003c/p\u003e\n\u003cp\u003eElse you would install a new instance on the new hardware and then restore backups of your databases on the new instance. You will need to migrate logins, jobs etc manually.\u003c/p\u003e\n\u003cp\u003eYou can use the \u003ca href=\"https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16\" rel=\"ugc nofollow\"\u003eData Migration Assistant\u003c/a\u003e to find out if there are backwards compatibility issues that you need to address before the upgrade. I've never used this tool myself, but generally, the number of breaking changes are small.\u003c/p\u003e\n\u003cp\u003eThe area where you are most likely to experience setbacks is performance. Microsoft makes changes to the optimizer in every release, and the idea is of course that these changes will result in better performance overall. However, due to the nature of optimization with estimates from sampled statistics, these changes can backfire. \u003c/p\u003e\n\u003cp\u003eThankfully, SQL Server 2022 comes with features that makes it easier to deal with these. The first thing should is to enable Query Store for all databases. Then make sure that all databases remain in compatibility level 120, so that you run with the optimizer of SQL 2014. Run with this setup for 1-2 weeks. Then you flip the compat level to 160. If you get performance regressions, you can use Query Store to force the old plan from compat level 120 to fix the urgent problem, while you investigate a better long-term solution.\u003c/p\u003e\n\u003cp\u003eThere is also a tool in \u003ca href=\"https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?WT.mc_id=DP-MVP-5440\" rel=\"ugc nofollow\"\u003erecent versions of SSMS\u003c/a\u003e that can help you with this process. Right-click a database, select Tasks from the context menu, and at the bottom, you find the alternative Database Upgrade.\u003c/p\u003e\n","upvoteCount":0,"author":"Erland Sommarskog","authorId":"90918973-4b3b-4e75-a7e9-f4afda2f6e06","url":"https://learn.microsoft.com/en-us/answers/a/1877230"},{"@type":"Answer","id":1877502,"text":"\u003cp\u003eHi \u003ca href=\"/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00\" rel=\"ugc nofollow\"\u003e@Tarik sendro \u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eYou need to ensure the hardware and operating system meet SQL Server 2022’s requirements.\u003c/p\u003e\n\u003cp\u003eSee this doc: \u003ca href=\"https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2022?view=sql-server-ver16\" rel=\"ugc nofollow\"\u003eSQL Server 2022: Hardware and software requirements\u003c/a\u003e.\u003c/p\u003e\n\u003cblockquote\u003e\n\u003cp\u003ewhat is most easy way\u003c/p\u003e\n\u003c/blockquote\u003e\n\u003cp\u003eMostly speaking, the Side-by-Side Migration approach is often considered instead of in-place upgrade.\u003c/p\u003e\n\u003cp\u003eBest regards,\u003c/p\u003e\n\u003cp\u003eCosmog\u003c/p\u003e\n\u003chr /\u003e\n\u003cp\u003eIf the answer is the right solution, please click \u0026quot;Accept Answer\u0026quot; and kindly upvote it. If you have extra questions about this answer, please click \u0026quot;Comment\u0026quot;.\u003c/p\u003e\n","upvoteCount":0,"author":"LiHongMSFT-4306","authorId":"88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8","url":"https://learn.microsoft.com/en-us/answers/a/1877502"}]}} </script> </head> <header class="layout-body-header"> <div class="header-holder has-default-focus"> <a href="#main" style="z-index: 1070" class="outline-color-text visually-hidden-until-focused position-fixed inner-focus focus-visible top-0 left-0 right-0 padding-xs text-align-center background-color-body" >Skip to main content</a > <a href="#" data-skip-to-ask-learn style="z-index: 1070" class="outline-color-text visually-hidden-until-focused position-fixed inner-focus focus-visible top-0 left-0 right-0 padding-xs text-align-center background-color-body" hidden >Skip to Ask Learn chat experience</a > <div id="ignite-banner-holder" class="has-default-focus has-overflow-hidden"></div> <div hidden id="cookie-consent-holder" data-test-id="cookie-consent-container"></div>  <div id="unsupported-browser" style="background-color: white; color: black; padding: 16px; border-bottom: 1px solid grey;" hidden > <div style="max-width: 800px; margin: 0 auto;"> <p style="font-size: 24px">This browser is no longer supported.</p> <p style="font-size: 16px; margin-top: 16px;"> Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. </p> <div style="margin-top: 12px;"> <a href="https://go.microsoft.com/fwlink/p/?LinkID=2092881 " style="background-color: #0078d4; border: 1px solid #0078d4; color: white; padding: 6px 12px; border-radius: 2px; display: inline-block;" > Download Microsoft Edge </a> <a href="https://learn.microsoft.com/en-us/lifecycle/faq/internet-explorer-microsoft-edge" style="background-color: white; padding: 6px 12px; border: 1px solid #505050; color: #171717; border-radius: 2px; display: inline-block;" > More info about Internet Explorer and Microsoft Edge </a> </div> </div> </div>  <header id="ms--site-header" data-test-id="site-header-wrapper" role="banner" itemscope="itemscope" itemtype="http://schema.org/Organization" > <div id="ms--mobile-nav" class="site-header display-none-tablet padding-inline-none gap-none" data-bi-name="mobile-header" data-test-id="mobile-header" ></div> <div id="ms--primary-nav" class="site-header display-none display-flex-tablet" data-bi-name="L1-header" data-test-id="primary-header" ></div> <div id="ms--secondary-nav" class="site-header display-none display-flex-tablet" data-bi-name="L2-header" data-test-id="secondary-header" ></div> </header> </div> </header> <body id="body" data-bi-name="body" class="layout-body "> <main id="main" role="main" class="layout-body-main " data-bi-name="content" dir="ltr" > <div class="layout-padding padding-block-md margin-left-auto is-reading-width"> <div id="question-details" data-bi-name="qna-question-details-page-content"> <div id="article-header" class="margin-bottom-xs"> <div class="display-flex align-items-center"> <div id="article-header-page-actions" class="margin-left-auto display-flex flex-wrap-no-wrap align-items-stretch" > <button class="collection button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary button-sm display-none display-inline-flex-tablet" id="qna-add-to-collection-button-desktop" data-qna-add-to-collection-button data-test-id="add-to-collections-button-desktop" data-list-type="collection" data-bi-name="collection" data-list-item-title="this question" title="Add this question to a collection" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-circle-addition"></span> </span> <span class="collection-status is-visually-hidden" >Save</span > </button> <details class="popover popover-right" id="article-header-page-actions-overflow" data-test-id="page-actions-overflow-menu-button" > <summary class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-sm justify-content-flex-start button-primary " aria-label="Share this question" title="Share this question" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-more-vertical"></span> </span> </summary> <div class="popover-content padding-xs"> <button class="collection button button-clear text-decoration-none has-inner-focus margin-bottom-none button-sm button-block justify-content-flex-start has-inner-focus margin-none display-none-tablet" id="qna-add-to-collection-button-mobile" data-qna-add-to-collection-button data-test-id="add-to-collections-button-mobile" data-list-type="collection" data-bi-name="collection" data-list-item-title="this question" title="Add this question to a collection" > <span class="icon " aria-hidden="true"> <span class="docon docon-circle-addition"></span> </span> <span class="collection-status " >Save</span > </button> <div aria-hidden="true" class="margin-none display-none-tablet border-top" data-page-action-item="overflow-all" ></div> <h4 class="font-size-sm padding-left-xxs">Share via</h4> <a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F2119458%2Fpossibity-of-upgrade-and-migration-from-sql-2014-t " class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-sm button-block justify-content-flex-start has-inner-focus margin-none share-facebook" data-bi-name="facebook" data-page-action-item="overflow-all" > <span class="icon" aria-hidden="true"> <span class="docon docon-facebook-share font-size-md color-primary"></span> </span> <span class="margin-left-xxs color-text">Facebook</span> </a> <a href="https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F2119458%2Fpossibity-of-upgrade-and-migration-from-sql-2014-t &text=Possibity%20of%20upgrade%20and%20migration%20from%20%20SQL%202014%20%20to%20SQL%202022 &tw_p=tweetbutton&url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F2119458%2Fpossibity-of-upgrade-and-migration-from-sql-2014-t" class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-sm button-block justify-content-flex-start has-inner-focus margin-none share-twitter" data-bi-name="twitter" data-page-action-item="overflow-all" > <span class="icon" aria-hidden="true"> <span class="docon docon-xlogo-share color-text"></span> </span> <span class="margin-left-xxs color-text">x.com</span> </a> <a href="https://www.linkedin.com/cws/share?url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F2119458%2Fpossibity-of-upgrade-and-migration-from-sql-2014-t" class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-sm button-block justify-content-flex-start has-inner-focus margin-none share-linkedin" data-bi-name="linkedin" data-page-action-item="overflow-all" > <span class="icon" aria-hidden="true"> <span class="docon docon-linked-in-logo font-size-sm color-primary"></span> </span> <span class="margin-left-xxs color-text">LinkedIn</span> </a> <a href="mailto:?subject= %5BShared%20Question%5D%20Possibity%20of%20upgrade%20and%20migration%20from%20%20SQL%202014%20%20to%20SQL%202022&body=Possibity of upgrade and migration from SQL 2014 to SQL 2022https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F2119458%2Fpossibity-of-upgrade-and-migration-from-sql-2014-t" class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-sm button-block justify-content-flex-start has-inner-focus margin-none share-email" data-bi-name="email" data-page-action-item="overflow-all" > <span class="icon" aria-hidden="true"> <span class="docon docon-mail-message font-size-sm color-primary"></span> </span> <span class="margin-left-xxs color-text">Email</span> </a>  </div> </details> </div> </div> </div> <div id="thread-history-container" class="padding-block-md" hidden></div> <h1 class="title is-2">Possibity of upgrade and migration from SQL 2014 to SQL 2022</h1> <div class="level margin-none align-items-flex-start"> <div class="level-left flex-direction-column" data-id="8bc1fa1a-80bc-4765-a605-d580afc94b00"> <div class="display-flex align-items-center"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="eager" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Tarik sendro</a > </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="level-right margin-top-none"> <span class="font-size-xs"> <local-time format="datetime" datetime="2024-11-15T08:49:17.6066667+00:00" class="is-visually-hidden">2024-11-15T08:49:17.6066667+00:00</local-time> </span> </div> </div> <div class="content margin-top-xxs"><p>HI Team,</p> <p>I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way.</p> <p>Kind regards,</p> </div> <div class="tags margin-top-xs"> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server"> <span>SQL Server</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server" data-bi-name="tag-card-link" href="/en-us/answers/tags/191/sql-server/" > SQL Server </a> <div class="card-content-description" data-test-id="tag-card-description"> A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server"> 14,481 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9hdXRob3JpbmctZG9jcy1taWNyb3NvZnQucG9vbHBhcnR5LmJpei9kZXZyZWwvY2VkODQ2Y2MtNmEzYy00YzhmLTlkZmItM2RlMGU5MGUyNzQy class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> <details class="popover popover-left"> <summary class="tag has-text-wrap font-size-sm" data-test-id="question-tag-sql-server-migration-assistant"> <span>SQL Server Migration Assistant</span> </summary> <div class="popover-content width-350-tablet padding-none" data-test-id="tag-card-popover"> <article class="card border-left-lg border-left-color-accent"> <div class="card-content margin-bottom-none"> <a class="card-title" data-test-id="tag-card-title-sql-server-migration-assistant" data-bi-name="tag-card-link" href="/en-us/answers/tags/292/sql-server-migration-assistant/" > SQL Server Migration Assistant </a> <div class="card-content-description" data-test-id="tag-card-description"> A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE. </div> </div> <div class="card-template"> <div class="card-template-detail"> <span class="font-size-sm font-weight-semilight" data-test-id="tag-card-count-sql-server-migration-assistant"> 547 questions </span> </div> </div> <div class="card-footer"> <div class="card-footer-item"> <div class="buttons"> <button class="not-authenticated link-button font-size-sm margin-block-xs docs-sign-in" data-bi-name="follow-tag-sign-in" data-test-id="tag-card-follow-button-sql-server-migration-assistant" > Sign in to follow </button> <form action="/api/profiles/follow/tag/aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE" method="POST" new novalidate hidden data-follow-tag-id=aHR0cHM6Ly9taWNyb3NvZnQtZGV2cmVsLnBvb2xwYXJ0eS5iaXovRGV2UmVsT2ZmZXJpbmdPbnRvbG9neS9kM2FlMmY2MC1jYmIxLTQ2MmMtODllMi01ZTQwNDQyNzFkNjE class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-sm margin-block-xxs " data-bi-name=follow-tag type="submit" > Follow </button> </form> </div> </div> </div> </article> </div> </details> </div> <div class="margin-top-xxs"> <div class="level"> <div class="level-left"> <div class="display-none-tablet padding-top-xxs margin-right-xxs"> <a class="not-authenticated margin-bottom-sm link-button font-size-sm font-weight-semibold docs-sign-in" data-bi-name="follow-sign-in" href="#" > Sign in to follow </a> <form action="/api/profiles/follow/question/2119458?locale=en-us" method="POST" new novalidate hidden data-follow-question-id=2119458 class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" link-button font-size-sm font-weight-semibold " data-bi-name=follow-question type="submit" > Follow question </button> </form> </div> <div class="buttons"> <button class="comment-expander button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary is-hovered" aria-expanded=true aria-controls="question-2119458-expander" data-show-more="" data-title="Show comments for this question" data-bi-name="show-hide-comments" data-expanded-title="Hide comments for this question" data-test-id="question-Hide comments for this question" title="Hide comments for this question" > <span class="icon" aria-hidden="true"> <span class="docon docon-comment-outline"></span> </span> <span class="font-size-sm is-visually-hidden-mobile">2 comments</span> <span class="is-visually-hidden show-more-text"> Hide comments for this question </span> </button> <button title="Report a concern" class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary qna-report-post-button " data-list-type="report" data-bi-name="report" data-reportedUserId="8bc1fa1a-80bc-4765-a605-d580afc94b00" data-questionId="2119458" data-entityId="2119458" data-entityType="question" data-action="/api/questions/moderation/reportconcern?_method=PUT&locale=en-us" data-page-action-item="overflow-mobile" data-test-id="report-post-button-question-2119458" > <span class="icon " aria-hidden="true"> <span class="docon docon-flag"></span> </span> <span class="font-size-sm is-visually-hidden-mobile" >Report a concern</span > </button> <details class="popover display-none" id="answer-overflow-menu-2119458" data-test-id="overflow-menu-button" > <summary class="justify-content-flex-start align-items-center button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary" aria-label="More actions" title="More actions" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-more-vertical"></span> </span> </summary> <div class="popover-content padding-none" data-test-id="overflow-menu-content"> </div> </details> </div> </div> <div class="level-right is-full-height"> <div id="question-vote"> <button title="You have the same or similar question" class="not-authenticated link-button font-size-sm sign-in-modal" > I have the same question </button> <button id="question-vote-button" title="You have the same or similar question" class="authenticated link-button font-size-sm " data-id="2119458" data-vote-count="0" data-bi-name="question-vote-up" > I have the same question </button> <span id="question-vote-total" class="tag is-small border-radius-rounded margin-left-xxs " > <span class="vote-count" aria-hidden="true">0</span> <span class="vote-text visually-hidden" >{count} votes</span > </span> </div> </div> </div> <div class="question-vote-error"></div> <div id="question-2119458-expander" class="width-full"> <div class="expandable is-expanded"> <div id="question-2119458-moreThan"> <ol> <li id="comment-1847143" data-test-id="comment-1847143" data="0" class="margin-top-xxs is-unstyled padding-block-xxs margin-bottom-xxs " > <div class="display-flex flex-direction-row"> <div class="image is-32x32 margin-top-xs margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="eager" alt="" src="https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953" /> </div> <div class="background-color-body-medium padding-xs is-full-width border-radius-lg"> <div class="level margin-none align-items-flex-start" > <div class="level-left flex-direction-column" data-id="88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8"> <div class="display-flex align-items-center"> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >LiHongMSFT-4306</a > <span hidden aria-hidden="true" data-bi-name="user-follow-separator"> • </span > <form action="/api/profiles/follow/user/88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8?locale=en-us" method="POST" new novalidate hidden data-follow-user-id=88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8 class="authenticated display-inline-block" > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" link-button font-size-sm font-weight-semibold " data-bi-name=follow-user type="submit" > Follow </button> </form> </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">30,671</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="level-right margin-top-none"> <span class="font-size-xs"> <local-time format="datetime" datetime="2024-11-22T07:18:50.5+00:00" class="is-visually-hidden">2024-11-22T07:18:50.5+00:00</local-time> </span> </div> </div> <div> <div class="content font-size-sm"> <p>Hi <a href="/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00" rel="ugc nofollow">@Tarik sendro </a></p> <p>Do you have further question on this issue, could we offer more support?</p> <p>If any answer is helpful to your question, please accept it as an answer so that other users with similar questions can see it more easily. :)</p> </div> </div> </div> </div> <div class="margin-top-xxs margin-left-md padding-left-xxs comment-holder" > <button class="comment-vote button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary button-sm sign-in-modal " title="This comment is helpful" data-bi-name="comment-vote-up" data-id="1847143" data-vote-count="0" > <span class="icon" aria-hidden="true"> <span class="docon docon-like"></span> </span> <span class="vote-text is-visually-hidden-mobile">0 votes</span> </button> <button title="Report a concern" class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary qna-report-post-button button-sm " data-list-type="report" data-bi-name="report" data-reportedUserId="88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8" data-questionId="2119458" data-entityId="1847143" data-entityType="comment" data-action="/api/questions/moderation/reportconcern?_method=PUT&locale=en-us" data-page-action-item="overflow-mobile" data-test-id="report-post-button-comment-1847143" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-flag"></span> </span> <span class="is-visually-hidden" >Report a concern</span > </button> <details class="popover display-none" id="answer-overflow-menu-1847143" data-test-id="overflow-menu-button" > <summary class="justify-content-flex-start align-items-center button button-clear text-decoration-none has-inner-focus margin-bottom-none button-sm button-primary" aria-label="More actions" title="More actions" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-more-vertical"></span> </span> </summary> <div class="popover-content padding-none" data-test-id="overflow-menu-content"> </div> </details> <div class="comment-vote-error"></div> </div> </li> <li id="comment-1847418" data-test-id="comment-1847418" data="1" class="margin-top-xxs is-unstyled padding-block-xxs " > <div class="display-flex flex-direction-row"> <div class="image is-32x32 margin-top-xs margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="eager" alt="" src="data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E" /> </div> <div class="background-color-body-medium padding-xs is-full-width border-radius-lg"> <div class="level margin-none align-items-flex-start" > <div class="level-left flex-direction-column" data-id="8bc1fa1a-80bc-4765-a605-d580afc94b00"> <div class="display-flex align-items-center"> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Tarik sendro</a > <span hidden aria-hidden="true" data-bi-name="user-follow-separator"> • </span > <form action="/api/profiles/follow/user/8bc1fa1a-80bc-4765-a605-d580afc94b00?locale=en-us" method="POST" new novalidate hidden data-follow-user-id=8bc1fa1a-80bc-4765-a605-d580afc94b00 class="authenticated display-inline-block" > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" link-button font-size-sm font-weight-semibold " data-bi-name=follow-user type="submit" > Follow </button> </form> </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">0</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="level-right margin-top-none"> <span class="font-size-xs"> <local-time format="datetime" datetime="2024-11-22T14:37:11.7166667+00:00" class="is-visually-hidden">2024-11-22T14:37:11.7166667+00:00</local-time> </span> </div> </div> <div> <div class="content font-size-sm"> <p>Hi Guys, Thanks for very fast info , the installed OS is Windows server 2019. They don't plane to upgrade hardware.Best regards,</p> </div> </div> </div> </div> <div class="margin-top-xxs margin-left-md padding-left-xxs comment-holder" > <button class="comment-vote button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary button-sm sign-in-modal " title="This comment is helpful" data-bi-name="comment-vote-up" data-id="1847418" data-vote-count="0" > <span class="icon" aria-hidden="true"> <span class="docon docon-like"></span> </span> <span class="vote-text is-visually-hidden-mobile">0 votes</span> </button> <button title="Report a concern" class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary qna-report-post-button button-sm " data-list-type="report" data-bi-name="report" data-reportedUserId="8bc1fa1a-80bc-4765-a605-d580afc94b00" data-questionId="2119458" data-entityId="1847418" data-entityType="comment" data-action="/api/questions/moderation/reportconcern?_method=PUT&locale=en-us" data-page-action-item="overflow-mobile" data-test-id="report-post-button-comment-1847418" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-flag"></span> </span> <span class="is-visually-hidden" >Report a concern</span > </button> <details class="popover display-none" id="answer-overflow-menu-1847418" data-test-id="overflow-menu-button" > <summary class="justify-content-flex-start align-items-center button button-clear text-decoration-none has-inner-focus margin-bottom-none button-sm button-primary" aria-label="More actions" title="More actions" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-more-vertical"></span> </span> </summary> <div class="popover-content padding-none" data-test-id="overflow-menu-content"> </div> </details> <div class="comment-vote-error"></div> </div> </li> </ol> </div> </div> </div> <hr class="hr margin-block-xxs" /> <a class="not-authenticated link-button font-size-sm margin-right-sm docs-sign-in" data-bi-name="comment-sign-in" href="#" > Sign in to comment </a> <div class="authenticated columns margin-top-xs"> <div class="column is-narrow padding-right-none display-none display-flex-tablet"> <div class="image is-32x32"> </div> </div> <div class="column is-11 flex-grow-1"> <button class="button button-secondary button-block button-sm justify-content-flex-start color-text-subtle font-weight-normal" aria-expanded="false" aria-controls="question-comment-editor-expander" data-show-more="" data-title="Add comment" data-bi-name="add-comment" data-expanded-title="Add comment" data-show-once="true" title="Add comment" > Add comment </button> <div id="question-comment-editor-expander" > <div class="expandable"> <div class="column is-12"> <form action="/api/questions/2119458/comments?locale=en-us&translated=false" method="POST" data-form-type="comment" data-question-id="2119458" new novalidate > <form-behavior navigation="hash-reload" navigation-href=?comment=question#newest-question-comment header-content-type="application/json" header-X-DocsAuth="cookie" new noUnload loc-content-has-changed="Content has changed, please reload the page to get the latest changes." loc-input-max-length="{inputLabel} cannot be longer than {maxLength} characters." loc-input-min-length="{inputLabel} must be at least {minLength} characters." loc-input-required="{inputLabel} is required." loc-not-authenticated="You are not authenticated. Please refresh the page and try again. If this issue persists, please log out and log back in." loc-not-authorized="You are not authorized to make this response. If you believe this to be in error, please refresh the page and try again." loc-please-fix-the-following-issues="Please fix the following issues to continue:" loc-there-are-no-edits-to-submit="There are no edits to submit." loc-too-many-requests="You have sent too many requests. Please wait a few minutes and try again." loc-we-encountered-an-unexpected-error="We encountered an unexpected error. Please try again later. If this issue continues, please contact site support." ></form-behavior> <input hidden aria-hidden="true" name="locale" value="en-us" /> <div class="field"> <label class="label margin-none" for="body-2119458-comment" hidden> Comment </label> <span id="qna-comment-hint" class="field-description help margin-bottom-xxs" >Use comments to ask for clarification, additional information, or improvements to the question.</span > <div class="field-body"> <docs-markdown-editor aria-describedby="qna-comment-hint" initialHeightClass="hmn1" isLocal="false" isProduction="true" mode="qna" locStrings="{"loc_admin_markdownEditor":"Markdown Editor","loc_admin_markdownEditor_aDescriptionForTheImage":"A description for the image","loc_admin_markdownEditor_address":"Address","loc_admin_markdownEditor_apply":"Apply","loc_admin_markdownEditor_alert":"Alert","loc_admin_markdownEditor_attachment":"Attachment","loc_admin_markdownEditor_attachment_browse":"Browse","loc_admin_markdownEditor_attachment_maxSize":"Max size {maxSize} MB","loc_admin_markdownEditor_attachment_sizeLessThanMinimum":"The attachment does not meet the minimum required size. The min size is 1 byte.","loc_admin_markdownEditor_attachment_sizeMoreThanMaximum":"The attachment exceeds the maximum size allowed. The max size is 3145728 bytes.","loc_admin_markdownEditor_attachment_extensionNotPermitted":"The attachment extension is not valid. It could be caused by a wrong attachment signature. Valid extensions are .xml, .pdf, .txt, .log, .gif, .png, .jpg, .jpeg.","loc_admin_markdownEditor_attachment_numberMoreThanMaximum":"The number of attachments exceed the maximum number allowed. Upload up to 20 attachments.","loc_admin_markdownEditor_attachment_platformInvalid":"Platform is not supported.","loc_admin_markdownEditor_attachment_internalServerError":"Internal server error.","loc_admin_markdownEditor_attachment_unauthorizedRequest":"Unauthorized request. Please make sure you are using the correct credential.","loc_admin_markdownEditor_blockquote":"Blockquote","loc_admin_markdownEditor_bold":"Bold","loc_admin_markdownEditor_bulletedList":"Bulleted list","loc_admin_markdownEditor_caution":"Caution","loc_admin_markdownEditor_cancel":"Cancel","loc_admin_markdownEditor_code":"Code","loc_admin_markdownEditor_codeBlock":"Code block","loc_admin_markdownEditor_codeBlockLanguagePlaceholder":"Select development language","loc_admin_markdownEditor_codeBlockLanguage":"Select development language","loc_admin_markdownEditor_codeBlockLanguageEdit":"Edit development language","loc_admin_markdownEditor_complex":"Complex","loc_admin_markdownEditor_content":"Content","loc_admin_markdownEditor_disabled":"Disabled","loc_admin_markdownEditor_displayText":"Display text","loc_admin_markdownEditor_devLangsInputPlaceholder":"Search for a language","loc_admin_markdownEditor_file":"File","loc_admin_markdownEditor_fileUpload":", drag & drop, or paste a file.","loc_admin_markdownEditor_fileUploadFailedMessage":"File upload failed. Please try again.","loc_admin_markdownEditor_headings":"Headings","loc_admin_markdownEditor_heading":"Heading {number}","loc_admin_markdownEditor_help":"Help","loc_admin_markdownEditor_horizontalRule":"Horizontal rule","loc_admin_markdownEditor_icon":"Icon","loc_admin_markdownEditor_image":"Image","loc_admin_markdownEditor_imageAlt":"User's image","loc_admin_markdownEditor_imageUpload":", drag & drop, or paste an image","loc_admin_markdownEditor_imageUploadFailedMessage":"Image upload failed. Please try again.","loc_admin_markdownEditor_imageBorder":"Image border","loc_admin_markdownEditor_imageDescription":"Image description","loc_admin_markdownEditor_imageDescriptionAltText":"Image description (alt text)","loc_admin_markdownEditor_imageDescriptionAltTextPlaceholder":"Enter a description (alt text) for the image","loc_admin_markdownEditor_imageHasALightbox":"Image has a lightbox","loc_admin_markdownEditor_imageLightbox":"Image lightbox","loc_admin_markdownEditor_imageLocScope":"Image loc-scope","loc_admin_markdownEditor_imageSource":"Image source","loc_admin_markdownEditor_important":"Important","loc_admin_markdownEditor_inlineCode":"Inline Code","loc_admin_markdownEditor_insertCodeBlock":"Insert code block","loc_admin_markdownEditor_insertFile":"Insert file","loc_admin_markdownEditor_insertHorizontalRule":"Insert horizontal rule","loc_admin_markdownEditor_insertImage":"Insert image","loc_admin_markdownEditor_insertLink":"Insert link","loc_admin_markdownEditor_insertTable":"Insert table","loc_admin_markdownEditor_italics":"Italics","loc_admin_markdownEditor_link":"Link","loc_admin_markdownEditor_markdown":"Markdown","loc_admin_markdownEditor_noMatches":"We couldn't find any matches.","loc_admin_markdownEditor_note":"Note","loc_admin_markdownEditor_numberedList":"Numbered list","loc_admin_markdownEditor_pleaseSelectImageType":"Please select image type","loc_admin_markdownEditor_quote":"Quote","loc_admin_markdownEditor_redo":"Redo","loc_admin_markdownEditor_remove":"Remove","loc_admin_markdownEditor_removeLink":"Remove link","loc_admin_markdownEditor_save":"Save","loc_admin_markdownEditor_saveNewLink":"Save Link","loc_admin_markdownEditor_selectImageTypePlaceholder":"Select an image type","loc_admin_markdownEditor_showCountResults":"Showing {count} results","loc_admin_markdownEditor_strikethrough":"Strikethrough","loc_admin_markdownEditor_suggestions":"Suggestions","loc_admin_markdownEditor_table":"Table","loc_admin_markdownEditor_table_column":"Column","loc_admin_markdownEditor_table_editTable":"Edit table","loc_admin_markdownEditor_table_insertColumnAfter":"Insert column after","loc_admin_markdownEditor_table_insertColumnBefore":"Insert column before","loc_admin_markdownEditor_table_insertRowBefore":"Insert row after","loc_admin_markdownEditor_table_insertRowAfter":"Insert row before","loc_admin_markdownEditor_table_removeColumn":"Remove column","loc_admin_markdownEditor_table_row":"Row","loc_admin_markdownEditor_table_removeRow":"Remove row","loc_admin_markdownEditor_tip":"Tip","loc_admin_markdownEditor_toggleMarkdownEditing":"Toggle Markdown editing","loc_admin_markdownEditor_typeHere":"Type here","loc_admin_markdownEditor_undo":"Undo","loc_admin_markdownEditor_validations":"Validation","loc_admin_markdownEditor_validations_altTextEndWithPeriod":"Alt text should end with a period.","loc_admin_markdownEditor_validations_altTextStartWithUppercaseLetter":"Alt text should start with an uppercase letter.","loc_admin_markdownEditor_validations_altTextTooLong":"Alt text too long. The max is 150 characters, including spaces.","loc_admin_markdownEditor_validations_imageWidthTooLarge":"invalid file width","loc_admin_markdownEditor_validations_imageWidthTooLargeMessage":"Image too large. Resize to a max of 1200 pixels on each side.","loc_admin_markdownEditor_validations_imageCorrupted":"image corrupted","loc_admin_markdownEditor_validations_imageCorruptedMessage":"Image corrupted or it is not a valid image","loc_admin_markdownEditor_validations_imageInvalidPosition":"invalid image position","loc_admin_markdownEditor_validations_imageInvalidPositionMessage":"Inline images aren't supported. Add your image on a new line.","loc_admin_markdownEditor_validations_attachmentTooLarge":"attachment too large","loc_admin_markdownEditor_validations_attachmentInvalidName":"attachment invalid name","loc_admin_markdownEditor_validations_attachmentInvalidNameMessage":"Attachment upload error. Invalid characters in attachment name. Only letters, numbers, and hyphens (-) are allowed.","loc_admin_markdownEditor_validations_attachmentInvalidExtension":"Invalid attachment extension","loc_admin_markdownEditor_validations_attachmentTooSmall":"attachment too small","loc_admin_markdownEditor_validations_qnaAttachmentTooSmallMessage":"Attachment upload error. {filename} is too small to upload (less than {minSize} byte).","loc_admin_markdownEditor_validations_multipleAttachments":"Multiple attachments","loc_admin_markdownEditor_validations_qnaMultipleAttachmentsMessage":"Attachment upload error. You are adding {filecount} attachments and the maximum allowed is {maxCount}. Some attachments were not uploaded.","loc_admin_markdownEditor_validations_qnaAttachmentTooLargeMessage":"Attachment upload error. {filename} is too large to upload (more than {maxSize} MB).","loc_admin_markdownEditor_validations_qnaAttachmentInvalidExtensionMessage":"Attachment upload error. {filename} has an invalid extension. Valid extensions are {validExtensions}.","loc_admin_markdownEditor_validations_qnaAttachmentInvalidNameMessage":"Attachment upload error. {filename} has an invalid character in Unix and Windows system, for other limitations, please go to websites to check: https://kb.acronis.com/content/39790, http://en.wikipedia.org/wiki/C0_and_C1_control_codes.","loc_admin_markdownEditor_viewMarkdown":"View Markdown","loc_admin_markdownEditor_viewRichText":"View rich text","loc_admin_markdownEditor_warning":"Warning"}" placeHolder="Do not use comments to answer questions." isrtl=false > </docs-markdown-editor> <textarea hidden id="body-2119458-comment" aria-label="Comment" class="textarea" name="body" rows="1" data-expanded-rows="5" placeholder="Add a comment..." minlength="5" required ></textarea> <input id="attachment-count" aria-label="attachmentCount" class="attachment-input input" maxCount="20" hidden data-skip-validation /> </div> </div> <div class="control"> <div class="level"> <div class="level-left align-items-flex-start"><div aria-live="polite" class="qna-saved-draft has-text-left font-size-xs"></div></div> <div class="level-right margin-top-xxs margin-top-none-tablet"> <div class="buttons justify-content-flex-end"> <button data-modal-type="qna-discard-draft" class="button button-clear" data-bi-name="comment-discard-draft" data-question-id="2119458" type="button" hidden="true" > <span class="icon" aria-hidden="true"> <span class="docon docon-delete"></span> </span> <span>Discard draft</span> </button> <button type="submit" data-bi-name="comment-submit" class="button button-primary button-filled margin-right-none" > Add comment </button> </div> </div> </div> </div> </form> </div> </div> </div> </div> </div> </div> </div> <div id="answers" class="column margin-top-sm is-full"> <div class="margin-top-xxs"> <div class="level"> <div class="level-left"> <h2 class="title is-4">2 answers</h2> </div> <div class="level-right"> <details class="popover"> <summary class="button button-clear" data-test-id="sortby-popover-button"> <span >Sort by: <span class="has-text-primary font-weight-semibold"> Most helpful <span class="icon" aria-hidden="true"> <span class="expanded-indicator docon docon-chevron-down-light"></span> </span> </span></span > </summary> <div class="popover-content padding-none" data-test-id="sortby-menu"> <a aria-label="Sort by: Most helpful" class="button button-clear has-inner-focus button-block text-decoration-none justify-content-flex-start is-hovered" aria-current=page href="?orderby=helpful&page=1#answers" data-test-id="sortby-filter-link-helpful" >Most helpful</a > <a aria-label="Sort by: Newest" class="button button-clear has-inner-focus button-block text-decoration-none justify-content-flex-start " href="?orderby=newest&page=1#answers" data-test-id="sortby-filter-link-newest" >Newest</a > <a aria-label="Sort by: Oldest" class="button button-clear has-inner-focus button-block text-decoration-none justify-content-flex-start " href="?orderby=oldest&page=1#answers" data-test-id="sortby-filter-link-oldest" >Oldest</a > </div> </details> </div> </div> <ol class="list-style-none"> <li id="answer-1877230" class="margin-bottom-sm padding-block-sm border border-radius-lg" itemprop="suggestedAnswer" itemscope itemtype="https://schema.org/Answer0" data-test-id="answer-1877230" > <div class="columns is-multiline margin-left-xs margin-right-xs" > <div class="column is-12"> <div class="level margin-none align-items-flex-start"> <div class="level-left flex-direction-column" data-id="90918973-4b3b-4e75-a7e9-f4afda2f6e06"> <div class="display-flex align-items-center"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=90918973-4b3b-4e75-a7e9-f4afda2f6e06" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >Erland Sommarskog</a > <span hidden aria-hidden="true" data-bi-name="user-follow-separator"> • </span > <form action="/api/profiles/follow/user/90918973-4b3b-4e75-a7e9-f4afda2f6e06?locale=en-us" method="POST" new novalidate hidden data-follow-user-id=90918973-4b3b-4e75-a7e9-f4afda2f6e06 class="authenticated display-inline-block" > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" link-button font-size-sm font-weight-semibold " data-bi-name=follow-user type="submit" > Follow </button> </form> </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">117.1K</span> <span class="is-visually-hidden">Reputation points</span> <span aria-hidden="true">• </span>MVP </span> </div> </div> </div> <div class="level-right margin-top-none"> <span class="font-size-xs"> <local-time format="datetime" datetime="2024-11-16T09:51:19.3+00:00" class="is-visually-hidden">2024-11-16T09:51:19.3+00:00</local-time> </span> </div> </div> <div> <div class="content" itemprop="text"><p>I assume that you have SQL 2014 Standard Edition. Can you share the output of SELECT @@version?</p> <p>It is certainly possible, but as for what is the easiest way, that depends on the situation.</p> <p>In many cases when you move to a new version of SQL Server, you also migrate to new hardware, not the least when the leap is this big. An important factor here is also the operating system. What OS do you have? If you have a really old OS, it may not be supported by SQL 2022. Which is one more reason to move to new hardware.</p> <p>Also, is this is a physical machine or virtual machine? Virtual machines permits you to clone or snapshot them and run a test upgrade. With a physical machine, you need to cross Rubicon directly. (Since you specify the hardware specs, I assume that it is physical.)</p> <p>If you want to keep the hardware, and the OS is Window Server 2016 or later, you can run an in-place upgrade. This is a supported <a href="https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16" rel="ugc nofollow">version upgrade</a>.</p> <p>Else you would install a new instance on the new hardware and then restore backups of your databases on the new instance. You will need to migrate logins, jobs etc manually.</p> <p>You can use the <a href="https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16" rel="ugc nofollow">Data Migration Assistant</a> to find out if there are backwards compatibility issues that you need to address before the upgrade. I've never used this tool myself, but generally, the number of breaking changes are small.</p> <p>The area where you are most likely to experience setbacks is performance. Microsoft makes changes to the optimizer in every release, and the idea is of course that these changes will result in better performance overall. However, due to the nature of optimization with estimates from sampled statistics, these changes can backfire. </p> <p>Thankfully, SQL Server 2022 comes with features that makes it easier to deal with these. The first thing should is to enable Query Store for all databases. Then make sure that all databases remain in compatibility level 120, so that you run with the optimizer of SQL 2014. Run with this setup for 1-2 weeks. Then you flip the compat level to 160. If you get performance regressions, you can use Query Store to force the old plan from compat level 120 to fix the urgent problem, while you investigate a better long-term solution.</p> <p>There is also a tool in <a href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?WT.mc_id=DP-MVP-5440" rel="ugc nofollow">recent versions of SSMS</a> that can help you with this process. Right-click a database, select Tasks from the context menu, and at the bottom, you find the alternative Database Upgrade.</p> </div> </div> <div> <div class="margin-block-xxs padding-xs background-color-body-medium font-size-sm display-flex flex-direction-column border-radius-lg" > <div class="display-flex justify-content-space-between flex-wrap-wrap align-items-baseline"> <div class="display-flex flex-grow-1"> <form method="POST" id="answer-rating-form-1877230" data-answer-id="1877230" new novalidate class="width-full" > <form-behavior header-X-DocsAuth="cookie" new></form-behavior> <div class="display-flex justify-content-space-between align-items-center flex-wrap-wrap" > <div class="field display-inline-flex flex-wrap-wrap align-items-center margin-bottom-none" > <label class="field-label margin-bottom-none margin-right-xs" for="answer-helpful-rating-1877230" > <a class="not-authenticated link-button font-size-sm margin-right-sm docs-sign-in" data-bi-name="answer-rating-sign-in" href="#" > Please sign in to rate this answer. </a> </label> <div id="answer-helpful-rating-1877230" class="field-body flex-grow-0 margin-top-none" > <button id="answer-rating-1877230-yes" class="authenticated thumb-rating button button-primary button-sm like" type="submit" form="answer-rating-form-1877230" formaction="/api/questions/answers/1877230/helpful/yes?_method=PUT&locale=en-us" data-action=/api/questions/answers/1877230/accept?_method=PUT&locale=en-us data-answer-rating-button data-bi-name="answer-rating-yes" title="This answer was helpful" > <span aria-hidden="true" class="icon docon docon-like"></span> <span>Yes</span> </button> <button id="answer-rating-1877230-no" class="authenticated thumb-rating button button-primary button-sm dislike" type="submit" form="answer-rating-form-1877230" formaction="/api/questions/answers/1877230/helpful/no?_method=PUT&locale=en-us" data-answer-rating-button data-bi-name="answer-rating-no" title="This answer was not helpful" > <span aria-hidden="true" class="icon docon docon-dislike"></span> <span>No</span> </button> </div> </div> <span class="margin-top-xxs margin-top-none-tablet" id="answer-helpful-text-1877230" ></span > </div> </form> </div> </div> </div> <div class="buttons margin-block-xxs margin-top-xs"> <span class="button button-clear text-decoration-none has-inner-focus margin-bottom-none font-size-md color-text-subtle align-self-flex-start" title="No comments" > <span class="icon" aria-hidden="true"> <span class="docon docon-comment-outline"></span> </span> <span class="font-size-sm is-visually-hidden-mobile">0 comments</span> <span class="visually-hidden">No comments</span> </span> <button title="Report a concern" class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary qna-report-post-button " data-list-type="report" data-bi-name="report" data-reportedUserId="90918973-4b3b-4e75-a7e9-f4afda2f6e06" data-questionId="2119458" data-entityId="1877230" data-entityType="answer" data-action="/api/questions/moderation/reportconcern?_method=PUT&locale=en-us" data-page-action-item="overflow-mobile" data-test-id="report-post-button-answer-1877230" > <span class="icon " aria-hidden="true"> <span class="docon docon-flag"></span> </span> <span class="font-size-sm is-visually-hidden-mobile" >Report a concern</span > </button> <details class="popover display-none" id="answer-overflow-menu-1877230" data-test-id="overflow-menu-button" > <summary class="justify-content-flex-start align-items-center button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary" aria-label="More actions" title="More actions" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-more-vertical"></span> </span> </summary> <div class="popover-content padding-none" data-test-id="overflow-menu-content"> </div> </details> </div> <div id="question-answer0-1877230-expander" class="width-full"> <div class="expandable "> <div id="question-answer0-1877230-moreThan"> <ol> </ol> </div> </div> </div> <hr class="hr margin-block-xxs" /> <a class="not-authenticated link-button font-size-sm margin-right-sm docs-sign-in" data-bi-name="comment-sign-in" href="#" > Sign in to comment </a> <div class="authenticated columns margin-top-xs"> <div class="column is-narrow padding-right-none display-none display-flex-tablet"> <div class="image is-32x32"> </div> </div> <div class="column is-11 flex-grow-1"> <button class="button button-secondary button-block button-sm justify-content-flex-start color-text-subtle font-weight-normal" aria-expanded="false" aria-controls="answer-comment-editor-1877230-expander" data-show-more="" data-title="Add comment" data-bi-name="add-comment" data-expanded-title="Add comment" data-show-once="true" title="Add comment" > Add comment </button> <div id="answer-comment-editor-1877230-expander" > <div class="expandable"> <div class="column is-12"> <form action="/api/questions/2119458/answers/1877230/comments?locale=en-us&translated=false" method="POST" data-form-type="answerComment" data-question-id="2119458" data-answer-id=1877230 new novalidate > <form-behavior navigation="hash-reload" navigation-href=?page=1&orderby=Helpful&comment=answer-1877230#newest-answer-comment header-content-type="application/json" header-X-DocsAuth="cookie" new noUnload loc-content-has-changed="Content has changed, please reload the page to get the latest changes." loc-input-max-length="{inputLabel} cannot be longer than {maxLength} characters." loc-input-min-length="{inputLabel} must be at least {minLength} characters." loc-input-required="{inputLabel} is required." loc-not-authenticated="You are not authenticated. Please refresh the page and try again. If this issue persists, please log out and log back in." loc-not-authorized="You are not authorized to make this response. If you believe this to be in error, please refresh the page and try again." loc-please-fix-the-following-issues="Please fix the following issues to continue:" loc-there-are-no-edits-to-submit="There are no edits to submit." loc-too-many-requests="You have sent too many requests. Please wait a few minutes and try again." loc-we-encountered-an-unexpected-error="We encountered an unexpected error. Please try again later. If this issue continues, please contact site support." ></form-behavior> <input hidden aria-hidden="true" name="locale" value="en-us" /> <div class="field"> <label class="label margin-none" for="body-2119458-1877230-answerComment" hidden> Comment </label> <span id="qna-answerComment-1877230-hint" class="field-description help margin-bottom-xxs" >Use comments to ask for clarification, additional information, or improvements to the question.</span > <div class="field-body"> <docs-markdown-editor aria-describedby="qna-answerComment-1877230-hint" initialHeightClass="hmn1" isLocal="false" isProduction="true" mode="qna" locStrings="{"loc_admin_markdownEditor":"Markdown Editor","loc_admin_markdownEditor_aDescriptionForTheImage":"A description for the image","loc_admin_markdownEditor_address":"Address","loc_admin_markdownEditor_apply":"Apply","loc_admin_markdownEditor_alert":"Alert","loc_admin_markdownEditor_attachment":"Attachment","loc_admin_markdownEditor_attachment_browse":"Browse","loc_admin_markdownEditor_attachment_maxSize":"Max size {maxSize} MB","loc_admin_markdownEditor_attachment_sizeLessThanMinimum":"The attachment does not meet the minimum required size. The min size is 1 byte.","loc_admin_markdownEditor_attachment_sizeMoreThanMaximum":"The attachment exceeds the maximum size allowed. The max size is 3145728 bytes.","loc_admin_markdownEditor_attachment_extensionNotPermitted":"The attachment extension is not valid. It could be caused by a wrong attachment signature. Valid extensions are .xml, .pdf, .txt, .log, .gif, .png, .jpg, .jpeg.","loc_admin_markdownEditor_attachment_numberMoreThanMaximum":"The number of attachments exceed the maximum number allowed. Upload up to 20 attachments.","loc_admin_markdownEditor_attachment_platformInvalid":"Platform is not supported.","loc_admin_markdownEditor_attachment_internalServerError":"Internal server error.","loc_admin_markdownEditor_attachment_unauthorizedRequest":"Unauthorized request. Please make sure you are using the correct credential.","loc_admin_markdownEditor_blockquote":"Blockquote","loc_admin_markdownEditor_bold":"Bold","loc_admin_markdownEditor_bulletedList":"Bulleted list","loc_admin_markdownEditor_caution":"Caution","loc_admin_markdownEditor_cancel":"Cancel","loc_admin_markdownEditor_code":"Code","loc_admin_markdownEditor_codeBlock":"Code block","loc_admin_markdownEditor_codeBlockLanguagePlaceholder":"Select development language","loc_admin_markdownEditor_codeBlockLanguage":"Select development language","loc_admin_markdownEditor_codeBlockLanguageEdit":"Edit development language","loc_admin_markdownEditor_complex":"Complex","loc_admin_markdownEditor_content":"Content","loc_admin_markdownEditor_disabled":"Disabled","loc_admin_markdownEditor_displayText":"Display text","loc_admin_markdownEditor_devLangsInputPlaceholder":"Search for a language","loc_admin_markdownEditor_file":"File","loc_admin_markdownEditor_fileUpload":", drag & drop, or paste a file.","loc_admin_markdownEditor_fileUploadFailedMessage":"File upload failed. Please try again.","loc_admin_markdownEditor_headings":"Headings","loc_admin_markdownEditor_heading":"Heading {number}","loc_admin_markdownEditor_help":"Help","loc_admin_markdownEditor_horizontalRule":"Horizontal rule","loc_admin_markdownEditor_icon":"Icon","loc_admin_markdownEditor_image":"Image","loc_admin_markdownEditor_imageAlt":"User's image","loc_admin_markdownEditor_imageUpload":", drag & drop, or paste an image","loc_admin_markdownEditor_imageUploadFailedMessage":"Image upload failed. Please try again.","loc_admin_markdownEditor_imageBorder":"Image border","loc_admin_markdownEditor_imageDescription":"Image description","loc_admin_markdownEditor_imageDescriptionAltText":"Image description (alt text)","loc_admin_markdownEditor_imageDescriptionAltTextPlaceholder":"Enter a description (alt text) for the image","loc_admin_markdownEditor_imageHasALightbox":"Image has a lightbox","loc_admin_markdownEditor_imageLightbox":"Image lightbox","loc_admin_markdownEditor_imageLocScope":"Image loc-scope","loc_admin_markdownEditor_imageSource":"Image source","loc_admin_markdownEditor_important":"Important","loc_admin_markdownEditor_inlineCode":"Inline Code","loc_admin_markdownEditor_insertCodeBlock":"Insert code block","loc_admin_markdownEditor_insertFile":"Insert file","loc_admin_markdownEditor_insertHorizontalRule":"Insert horizontal rule","loc_admin_markdownEditor_insertImage":"Insert image","loc_admin_markdownEditor_insertLink":"Insert link","loc_admin_markdownEditor_insertTable":"Insert table","loc_admin_markdownEditor_italics":"Italics","loc_admin_markdownEditor_link":"Link","loc_admin_markdownEditor_markdown":"Markdown","loc_admin_markdownEditor_noMatches":"We couldn't find any matches.","loc_admin_markdownEditor_note":"Note","loc_admin_markdownEditor_numberedList":"Numbered list","loc_admin_markdownEditor_pleaseSelectImageType":"Please select image type","loc_admin_markdownEditor_quote":"Quote","loc_admin_markdownEditor_redo":"Redo","loc_admin_markdownEditor_remove":"Remove","loc_admin_markdownEditor_removeLink":"Remove link","loc_admin_markdownEditor_save":"Save","loc_admin_markdownEditor_saveNewLink":"Save Link","loc_admin_markdownEditor_selectImageTypePlaceholder":"Select an image type","loc_admin_markdownEditor_showCountResults":"Showing {count} results","loc_admin_markdownEditor_strikethrough":"Strikethrough","loc_admin_markdownEditor_suggestions":"Suggestions","loc_admin_markdownEditor_table":"Table","loc_admin_markdownEditor_table_column":"Column","loc_admin_markdownEditor_table_editTable":"Edit table","loc_admin_markdownEditor_table_insertColumnAfter":"Insert column after","loc_admin_markdownEditor_table_insertColumnBefore":"Insert column before","loc_admin_markdownEditor_table_insertRowBefore":"Insert row after","loc_admin_markdownEditor_table_insertRowAfter":"Insert row before","loc_admin_markdownEditor_table_removeColumn":"Remove column","loc_admin_markdownEditor_table_row":"Row","loc_admin_markdownEditor_table_removeRow":"Remove row","loc_admin_markdownEditor_tip":"Tip","loc_admin_markdownEditor_toggleMarkdownEditing":"Toggle Markdown editing","loc_admin_markdownEditor_typeHere":"Type here","loc_admin_markdownEditor_undo":"Undo","loc_admin_markdownEditor_validations":"Validation","loc_admin_markdownEditor_validations_altTextEndWithPeriod":"Alt text should end with a period.","loc_admin_markdownEditor_validations_altTextStartWithUppercaseLetter":"Alt text should start with an uppercase letter.","loc_admin_markdownEditor_validations_altTextTooLong":"Alt text too long. The max is 150 characters, including spaces.","loc_admin_markdownEditor_validations_imageWidthTooLarge":"invalid file width","loc_admin_markdownEditor_validations_imageWidthTooLargeMessage":"Image too large. Resize to a max of 1200 pixels on each side.","loc_admin_markdownEditor_validations_imageCorrupted":"image corrupted","loc_admin_markdownEditor_validations_imageCorruptedMessage":"Image corrupted or it is not a valid image","loc_admin_markdownEditor_validations_imageInvalidPosition":"invalid image position","loc_admin_markdownEditor_validations_imageInvalidPositionMessage":"Inline images aren't supported. Add your image on a new line.","loc_admin_markdownEditor_validations_attachmentTooLarge":"attachment too large","loc_admin_markdownEditor_validations_attachmentInvalidName":"attachment invalid name","loc_admin_markdownEditor_validations_attachmentInvalidNameMessage":"Attachment upload error. Invalid characters in attachment name. Only letters, numbers, and hyphens (-) are allowed.","loc_admin_markdownEditor_validations_attachmentInvalidExtension":"Invalid attachment extension","loc_admin_markdownEditor_validations_attachmentTooSmall":"attachment too small","loc_admin_markdownEditor_validations_qnaAttachmentTooSmallMessage":"Attachment upload error. {filename} is too small to upload (less than {minSize} byte).","loc_admin_markdownEditor_validations_multipleAttachments":"Multiple attachments","loc_admin_markdownEditor_validations_qnaMultipleAttachmentsMessage":"Attachment upload error. You are adding {filecount} attachments and the maximum allowed is {maxCount}. Some attachments were not uploaded.","loc_admin_markdownEditor_validations_qnaAttachmentTooLargeMessage":"Attachment upload error. {filename} is too large to upload (more than {maxSize} MB).","loc_admin_markdownEditor_validations_qnaAttachmentInvalidExtensionMessage":"Attachment upload error. {filename} has an invalid extension. Valid extensions are {validExtensions}.","loc_admin_markdownEditor_validations_qnaAttachmentInvalidNameMessage":"Attachment upload error. {filename} has an invalid character in Unix and Windows system, for other limitations, please go to websites to check: https://kb.acronis.com/content/39790, http://en.wikipedia.org/wiki/C0_and_C1_control_codes.","loc_admin_markdownEditor_viewMarkdown":"View Markdown","loc_admin_markdownEditor_viewRichText":"View rich text","loc_admin_markdownEditor_warning":"Warning"}" placeHolder="Do not use comments to answer questions." isrtl=false > </docs-markdown-editor> <textarea hidden id="body-2119458-1877230-answerComment" aria-label="Comment" class="textarea" name="body" rows="1" data-expanded-rows="5" placeholder="Add a comment..." minlength="5" required ></textarea> <input id="attachment-count" aria-label="attachmentCount" class="attachment-input input" maxCount="20" hidden data-skip-validation /> </div> </div> <div class="control"> <div class="level"> <div class="level-left align-items-flex-start"><div aria-live="polite" class="qna-saved-draft has-text-left font-size-xs"></div></div> <div class="level-right margin-top-xxs margin-top-none-tablet"> <div class="buttons justify-content-flex-end"> <button data-modal-type="qna-discard-draft" class="button button-clear" data-bi-name="comment-discard-draft" data-question-id="2119458" data-answer-id=1877230 type="button" hidden="true" > <span class="icon" aria-hidden="true"> <span class="docon docon-delete"></span> </span> <span>Discard draft</span> </button> <button type="submit" data-bi-name="comment-submit" class="button button-primary button-filled margin-right-none" > Add comment </button> </div> </div> </div> </div> </form> </div> </div> </div> </div> </div> </div> </div> </div> </li> <li id="answer-1877502" class="margin-bottom-sm padding-block-sm border border-radius-lg" itemprop="suggestedAnswer" itemscope itemtype="https://schema.org/Answer1" data-test-id="answer-1877502" > <div class="columns is-multiline margin-left-xs margin-right-xs" > <div class="column is-12"> <div class="level margin-none align-items-flex-start"> <div class="level-left flex-direction-column" data-id="88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8"> <div class="display-flex align-items-center"> <div class="image is-32x32 margin-right-xxs"> <img class="border-radius-rounded background-color-body-medium" loading="lazy" alt="" src="https://techprofile.blob.core.windows.net/images/YC3KiAudCk6A0I6NB9vOyA.png?8DA953" /> </div> <div class="has-line-height-reset has-text-wrap width-250"> <span class="display-block" ><a href="/en-us/users/na/?userid=88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8" class="profile-url has-text-color font-weight-semibold font-size-sm" data-bi-name="user-link" >LiHongMSFT-4306</a > <span hidden aria-hidden="true" data-bi-name="user-follow-separator"> • </span > <form action="/api/profiles/follow/user/88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8?locale=en-us" method="POST" new novalidate hidden data-follow-user-id=88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8 class="authenticated display-inline-block" > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" link-button font-size-sm font-weight-semibold " data-bi-name=follow-user type="submit" > Follow </button> </form> </span> <span class=" display-block font-size-xs has-text-subtle" > <span title="Reputation points">30,671</span> <span class="is-visually-hidden">Reputation points</span> </span> </div> </div> </div> <div class="level-right margin-top-none"> <span class="font-size-xs"> <local-time format="datetime" datetime="2024-11-18T03:04:55.03+00:00" class="is-visually-hidden">2024-11-18T03:04:55.03+00:00</local-time> </span> </div> </div> <div> <div class="content" itemprop="text"><p>Hi <a href="/users/na/?userid=8bc1fa1a-80bc-4765-a605-d580afc94b00" rel="ugc nofollow">@Tarik sendro </a></p> <p>You need to ensure the hardware and operating system meet SQL Server 2022’s requirements.</p> <p>See this doc: <a href="https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2022?view=sql-server-ver16" rel="ugc nofollow">SQL Server 2022: Hardware and software requirements</a>.</p> <blockquote> <p>what is most easy way</p> </blockquote> <p>Mostly speaking, the Side-by-Side Migration approach is often considered instead of in-place upgrade.</p> <p>Best regards,</p> <p>Cosmog</p> <hr /> <p>If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".</p> </div> </div> <div> <div class="margin-block-xxs padding-xs background-color-body-medium font-size-sm display-flex flex-direction-column border-radius-lg" > <div class="display-flex justify-content-space-between flex-wrap-wrap align-items-baseline"> <div class="display-flex flex-grow-1"> <form method="POST" id="answer-rating-form-1877502" data-answer-id="1877502" new novalidate class="width-full" > <form-behavior header-X-DocsAuth="cookie" new></form-behavior> <div class="display-flex justify-content-space-between align-items-center flex-wrap-wrap" > <div class="field display-inline-flex flex-wrap-wrap align-items-center margin-bottom-none" > <label class="field-label margin-bottom-none margin-right-xs" for="answer-helpful-rating-1877502" > <a class="not-authenticated link-button font-size-sm margin-right-sm docs-sign-in" data-bi-name="answer-rating-sign-in" href="#" > Please sign in to rate this answer. </a> </label> <div id="answer-helpful-rating-1877502" class="field-body flex-grow-0 margin-top-none" > <button id="answer-rating-1877502-yes" class="authenticated thumb-rating button button-primary button-sm like" type="submit" form="answer-rating-form-1877502" formaction="/api/questions/answers/1877502/helpful/yes?_method=PUT&locale=en-us" data-action=/api/questions/answers/1877502/accept?_method=PUT&locale=en-us data-answer-rating-button data-bi-name="answer-rating-yes" title="This answer was helpful" > <span aria-hidden="true" class="icon docon docon-like"></span> <span>Yes</span> </button> <button id="answer-rating-1877502-no" class="authenticated thumb-rating button button-primary button-sm dislike" type="submit" form="answer-rating-form-1877502" formaction="/api/questions/answers/1877502/helpful/no?_method=PUT&locale=en-us" data-answer-rating-button data-bi-name="answer-rating-no" title="This answer was not helpful" > <span aria-hidden="true" class="icon docon docon-dislike"></span> <span>No</span> </button> </div> </div> <span class="margin-top-xxs margin-top-none-tablet" id="answer-helpful-text-1877502" ></span > </div> </form> </div> </div> </div> <div class="buttons margin-block-xxs margin-top-xs"> <span class="button button-clear text-decoration-none has-inner-focus margin-bottom-none font-size-md color-text-subtle align-self-flex-start" title="No comments" > <span class="icon" aria-hidden="true"> <span class="docon docon-comment-outline"></span> </span> <span class="font-size-sm is-visually-hidden-mobile">0 comments</span> <span class="visually-hidden">No comments</span> </span> <button title="Report a concern" class="button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary qna-report-post-button " data-list-type="report" data-bi-name="report" data-reportedUserId="88ca2d60-9d0b-4e0a-80d0-8e8d07dbcec8" data-questionId="2119458" data-entityId="1877502" data-entityType="answer" data-action="/api/questions/moderation/reportconcern?_method=PUT&locale=en-us" data-page-action-item="overflow-mobile" data-test-id="report-post-button-answer-1877502" > <span class="icon " aria-hidden="true"> <span class="docon docon-flag"></span> </span> <span class="font-size-sm is-visually-hidden-mobile" >Report a concern</span > </button> <details class="popover display-none" id="answer-overflow-menu-1877502" data-test-id="overflow-menu-button" > <summary class="justify-content-flex-start align-items-center button button-clear text-decoration-none has-inner-focus margin-bottom-none button-primary" aria-label="More actions" title="More actions" > <span class="icon margin-none" aria-hidden="true"> <span class="docon docon-more-vertical"></span> </span> </summary> <div class="popover-content padding-none" data-test-id="overflow-menu-content"> </div> </details> </div> <div id="question-answer1-1877502-expander" class="width-full"> <div class="expandable "> <div id="question-answer1-1877502-moreThan"> <ol> </ol> </div> </div> </div> <hr class="hr margin-block-xxs" /> <a class="not-authenticated link-button font-size-sm margin-right-sm docs-sign-in" data-bi-name="comment-sign-in" href="#" > Sign in to comment </a> <div class="authenticated columns margin-top-xs"> <div class="column is-narrow padding-right-none display-none display-flex-tablet"> <div class="image is-32x32"> </div> </div> <div class="column is-11 flex-grow-1"> <button class="button button-secondary button-block button-sm justify-content-flex-start color-text-subtle font-weight-normal" aria-expanded="false" aria-controls="answer-comment-editor-1877502-expander" data-show-more="" data-title="Add comment" data-bi-name="add-comment" data-expanded-title="Add comment" data-show-once="true" title="Add comment" > Add comment </button> <div id="answer-comment-editor-1877502-expander" > <div class="expandable"> <div class="column is-12"> <form action="/api/questions/2119458/answers/1877502/comments?locale=en-us&translated=false" method="POST" data-form-type="answerComment" data-question-id="2119458" data-answer-id=1877502 new novalidate > <form-behavior navigation="hash-reload" navigation-href=?page=1&orderby=Helpful&comment=answer-1877502#newest-answer-comment header-content-type="application/json" header-X-DocsAuth="cookie" new noUnload loc-content-has-changed="Content has changed, please reload the page to get the latest changes." loc-input-max-length="{inputLabel} cannot be longer than {maxLength} characters." loc-input-min-length="{inputLabel} must be at least {minLength} characters." loc-input-required="{inputLabel} is required." loc-not-authenticated="You are not authenticated. Please refresh the page and try again. If this issue persists, please log out and log back in." loc-not-authorized="You are not authorized to make this response. If you believe this to be in error, please refresh the page and try again." loc-please-fix-the-following-issues="Please fix the following issues to continue:" loc-there-are-no-edits-to-submit="There are no edits to submit." loc-too-many-requests="You have sent too many requests. Please wait a few minutes and try again." loc-we-encountered-an-unexpected-error="We encountered an unexpected error. Please try again later. If this issue continues, please contact site support." ></form-behavior> <input hidden aria-hidden="true" name="locale" value="en-us" /> <div class="field"> <label class="label margin-none" for="body-2119458-1877502-answerComment" hidden> Comment </label> <span id="qna-answerComment-1877502-hint" class="field-description help margin-bottom-xxs" >Use comments to ask for clarification, additional information, or improvements to the question.</span > <div class="field-body"> <docs-markdown-editor aria-describedby="qna-answerComment-1877502-hint" initialHeightClass="hmn1" isLocal="false" isProduction="true" mode="qna" locStrings="{"loc_admin_markdownEditor":"Markdown Editor","loc_admin_markdownEditor_aDescriptionForTheImage":"A description for the image","loc_admin_markdownEditor_address":"Address","loc_admin_markdownEditor_apply":"Apply","loc_admin_markdownEditor_alert":"Alert","loc_admin_markdownEditor_attachment":"Attachment","loc_admin_markdownEditor_attachment_browse":"Browse","loc_admin_markdownEditor_attachment_maxSize":"Max size {maxSize} MB","loc_admin_markdownEditor_attachment_sizeLessThanMinimum":"The attachment does not meet the minimum required size. The min size is 1 byte.","loc_admin_markdownEditor_attachment_sizeMoreThanMaximum":"The attachment exceeds the maximum size allowed. The max size is 3145728 bytes.","loc_admin_markdownEditor_attachment_extensionNotPermitted":"The attachment extension is not valid. It could be caused by a wrong attachment signature. Valid extensions are .xml, .pdf, .txt, .log, .gif, .png, .jpg, .jpeg.","loc_admin_markdownEditor_attachment_numberMoreThanMaximum":"The number of attachments exceed the maximum number allowed. Upload up to 20 attachments.","loc_admin_markdownEditor_attachment_platformInvalid":"Platform is not supported.","loc_admin_markdownEditor_attachment_internalServerError":"Internal server error.","loc_admin_markdownEditor_attachment_unauthorizedRequest":"Unauthorized request. Please make sure you are using the correct credential.","loc_admin_markdownEditor_blockquote":"Blockquote","loc_admin_markdownEditor_bold":"Bold","loc_admin_markdownEditor_bulletedList":"Bulleted list","loc_admin_markdownEditor_caution":"Caution","loc_admin_markdownEditor_cancel":"Cancel","loc_admin_markdownEditor_code":"Code","loc_admin_markdownEditor_codeBlock":"Code block","loc_admin_markdownEditor_codeBlockLanguagePlaceholder":"Select development language","loc_admin_markdownEditor_codeBlockLanguage":"Select development language","loc_admin_markdownEditor_codeBlockLanguageEdit":"Edit development language","loc_admin_markdownEditor_complex":"Complex","loc_admin_markdownEditor_content":"Content","loc_admin_markdownEditor_disabled":"Disabled","loc_admin_markdownEditor_displayText":"Display text","loc_admin_markdownEditor_devLangsInputPlaceholder":"Search for a language","loc_admin_markdownEditor_file":"File","loc_admin_markdownEditor_fileUpload":", drag & drop, or paste a file.","loc_admin_markdownEditor_fileUploadFailedMessage":"File upload failed. Please try again.","loc_admin_markdownEditor_headings":"Headings","loc_admin_markdownEditor_heading":"Heading {number}","loc_admin_markdownEditor_help":"Help","loc_admin_markdownEditor_horizontalRule":"Horizontal rule","loc_admin_markdownEditor_icon":"Icon","loc_admin_markdownEditor_image":"Image","loc_admin_markdownEditor_imageAlt":"User's image","loc_admin_markdownEditor_imageUpload":", drag & drop, or paste an image","loc_admin_markdownEditor_imageUploadFailedMessage":"Image upload failed. Please try again.","loc_admin_markdownEditor_imageBorder":"Image border","loc_admin_markdownEditor_imageDescription":"Image description","loc_admin_markdownEditor_imageDescriptionAltText":"Image description (alt text)","loc_admin_markdownEditor_imageDescriptionAltTextPlaceholder":"Enter a description (alt text) for the image","loc_admin_markdownEditor_imageHasALightbox":"Image has a lightbox","loc_admin_markdownEditor_imageLightbox":"Image lightbox","loc_admin_markdownEditor_imageLocScope":"Image loc-scope","loc_admin_markdownEditor_imageSource":"Image source","loc_admin_markdownEditor_important":"Important","loc_admin_markdownEditor_inlineCode":"Inline Code","loc_admin_markdownEditor_insertCodeBlock":"Insert code block","loc_admin_markdownEditor_insertFile":"Insert file","loc_admin_markdownEditor_insertHorizontalRule":"Insert horizontal rule","loc_admin_markdownEditor_insertImage":"Insert image","loc_admin_markdownEditor_insertLink":"Insert link","loc_admin_markdownEditor_insertTable":"Insert table","loc_admin_markdownEditor_italics":"Italics","loc_admin_markdownEditor_link":"Link","loc_admin_markdownEditor_markdown":"Markdown","loc_admin_markdownEditor_noMatches":"We couldn't find any matches.","loc_admin_markdownEditor_note":"Note","loc_admin_markdownEditor_numberedList":"Numbered list","loc_admin_markdownEditor_pleaseSelectImageType":"Please select image type","loc_admin_markdownEditor_quote":"Quote","loc_admin_markdownEditor_redo":"Redo","loc_admin_markdownEditor_remove":"Remove","loc_admin_markdownEditor_removeLink":"Remove link","loc_admin_markdownEditor_save":"Save","loc_admin_markdownEditor_saveNewLink":"Save Link","loc_admin_markdownEditor_selectImageTypePlaceholder":"Select an image type","loc_admin_markdownEditor_showCountResults":"Showing {count} results","loc_admin_markdownEditor_strikethrough":"Strikethrough","loc_admin_markdownEditor_suggestions":"Suggestions","loc_admin_markdownEditor_table":"Table","loc_admin_markdownEditor_table_column":"Column","loc_admin_markdownEditor_table_editTable":"Edit table","loc_admin_markdownEditor_table_insertColumnAfter":"Insert column after","loc_admin_markdownEditor_table_insertColumnBefore":"Insert column before","loc_admin_markdownEditor_table_insertRowBefore":"Insert row after","loc_admin_markdownEditor_table_insertRowAfter":"Insert row before","loc_admin_markdownEditor_table_removeColumn":"Remove column","loc_admin_markdownEditor_table_row":"Row","loc_admin_markdownEditor_table_removeRow":"Remove row","loc_admin_markdownEditor_tip":"Tip","loc_admin_markdownEditor_toggleMarkdownEditing":"Toggle Markdown editing","loc_admin_markdownEditor_typeHere":"Type here","loc_admin_markdownEditor_undo":"Undo","loc_admin_markdownEditor_validations":"Validation","loc_admin_markdownEditor_validations_altTextEndWithPeriod":"Alt text should end with a period.","loc_admin_markdownEditor_validations_altTextStartWithUppercaseLetter":"Alt text should start with an uppercase letter.","loc_admin_markdownEditor_validations_altTextTooLong":"Alt text too long. The max is 150 characters, including spaces.","loc_admin_markdownEditor_validations_imageWidthTooLarge":"invalid file width","loc_admin_markdownEditor_validations_imageWidthTooLargeMessage":"Image too large. Resize to a max of 1200 pixels on each side.","loc_admin_markdownEditor_validations_imageCorrupted":"image corrupted","loc_admin_markdownEditor_validations_imageCorruptedMessage":"Image corrupted or it is not a valid image","loc_admin_markdownEditor_validations_imageInvalidPosition":"invalid image position","loc_admin_markdownEditor_validations_imageInvalidPositionMessage":"Inline images aren't supported. Add your image on a new line.","loc_admin_markdownEditor_validations_attachmentTooLarge":"attachment too large","loc_admin_markdownEditor_validations_attachmentInvalidName":"attachment invalid name","loc_admin_markdownEditor_validations_attachmentInvalidNameMessage":"Attachment upload error. Invalid characters in attachment name. Only letters, numbers, and hyphens (-) are allowed.","loc_admin_markdownEditor_validations_attachmentInvalidExtension":"Invalid attachment extension","loc_admin_markdownEditor_validations_attachmentTooSmall":"attachment too small","loc_admin_markdownEditor_validations_qnaAttachmentTooSmallMessage":"Attachment upload error. {filename} is too small to upload (less than {minSize} byte).","loc_admin_markdownEditor_validations_multipleAttachments":"Multiple attachments","loc_admin_markdownEditor_validations_qnaMultipleAttachmentsMessage":"Attachment upload error. You are adding {filecount} attachments and the maximum allowed is {maxCount}. Some attachments were not uploaded.","loc_admin_markdownEditor_validations_qnaAttachmentTooLargeMessage":"Attachment upload error. {filename} is too large to upload (more than {maxSize} MB).","loc_admin_markdownEditor_validations_qnaAttachmentInvalidExtensionMessage":"Attachment upload error. {filename} has an invalid extension. Valid extensions are {validExtensions}.","loc_admin_markdownEditor_validations_qnaAttachmentInvalidNameMessage":"Attachment upload error. {filename} has an invalid character in Unix and Windows system, for other limitations, please go to websites to check: https://kb.acronis.com/content/39790, http://en.wikipedia.org/wiki/C0_and_C1_control_codes.","loc_admin_markdownEditor_viewMarkdown":"View Markdown","loc_admin_markdownEditor_viewRichText":"View rich text","loc_admin_markdownEditor_warning":"Warning"}" placeHolder="Do not use comments to answer questions." isrtl=false > </docs-markdown-editor> <textarea hidden id="body-2119458-1877502-answerComment" aria-label="Comment" class="textarea" name="body" rows="1" data-expanded-rows="5" placeholder="Add a comment..." minlength="5" required ></textarea> <input id="attachment-count" aria-label="attachmentCount" class="attachment-input input" maxCount="20" hidden data-skip-validation /> </div> </div> <div class="control"> <div class="level"> <div class="level-left align-items-flex-start"><div aria-live="polite" class="qna-saved-draft has-text-left font-size-xs"></div></div> <div class="level-right margin-top-xxs margin-top-none-tablet"> <div class="buttons justify-content-flex-end"> <button data-modal-type="qna-discard-draft" class="button button-clear" data-bi-name="comment-discard-draft" data-question-id="2119458" data-answer-id=1877502 type="button" hidden="true" > <span class="icon" aria-hidden="true"> <span class="docon docon-delete"></span> </span> <span>Discard draft</span> </button> <button type="submit" data-bi-name="comment-submit" class="button button-primary button-filled margin-right-none" > Add comment </button> </div> </div> </div> </div> </form> </div> </div> </div> </div> </div> </div> </div> </div> </li> </ol> <a class="not-authenticated link-button font-size-sm margin-right-sm docs-sign-in" href="#" > Sign in to answer </a> <div class="authenticated"> <h2 class="title is-4 margin-top-lg margin-bottom-xxs"> Your answer </h2> <form action="/api/questions/2119458/answers?locale=en-us&translated=false" method="POST" data-form-type="answer" data-question-id="2119458" new novalidate > <form-behavior navigation="hash-reload" navigation-href=?page=1&orderby=Helpful#answers header-content-type="application/json" header-X-DocsAuth="cookie" new noUnload loc-content-has-changed="Content has changed, please reload the page to get the latest changes." loc-input-max-length="{inputLabel} cannot be longer than {maxLength} characters." loc-input-min-length="{inputLabel} must be at least {minLength} characters." loc-input-required="{inputLabel} is required." loc-not-authenticated="You are not authenticated. Please refresh the page and try again. If this issue persists, please log out and log back in." loc-not-authorized="You are not authorized to make this response. If you believe this to be in error, please refresh the page and try again." loc-please-fix-the-following-issues="Please fix the following issues to continue:" loc-there-are-no-edits-to-submit="There are no edits to submit." loc-too-many-requests="You have sent too many requests. Please wait a few minutes and try again." loc-we-encountered-an-unexpected-error="We encountered an unexpected error. Please try again later. If this issue continues, please contact site support." ></form-behavior> <input hidden aria-hidden="true" name="locale" value="en-us" /> <div class="field"> <label class="label margin-none" for="body-2119458-answer" hidden> Answer </label> <span id="qna-answer-hint" class="field-description help margin-bottom-xxs" >Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.</span > <div class="field-body"> <docs-markdown-editor aria-describedby="qna-answer-hint" initialHeightClass="hmn2" isLocal="false" isProduction="true" mode="qna" locStrings="{"loc_admin_markdownEditor":"Markdown Editor","loc_admin_markdownEditor_aDescriptionForTheImage":"A description for the image","loc_admin_markdownEditor_address":"Address","loc_admin_markdownEditor_apply":"Apply","loc_admin_markdownEditor_alert":"Alert","loc_admin_markdownEditor_attachment":"Attachment","loc_admin_markdownEditor_attachment_browse":"Browse","loc_admin_markdownEditor_attachment_maxSize":"Max size {maxSize} MB","loc_admin_markdownEditor_attachment_sizeLessThanMinimum":"The attachment does not meet the minimum required size. The min size is 1 byte.","loc_admin_markdownEditor_attachment_sizeMoreThanMaximum":"The attachment exceeds the maximum size allowed. The max size is 3145728 bytes.","loc_admin_markdownEditor_attachment_extensionNotPermitted":"The attachment extension is not valid. It could be caused by a wrong attachment signature. Valid extensions are .xml, .pdf, .txt, .log, .gif, .png, .jpg, .jpeg.","loc_admin_markdownEditor_attachment_numberMoreThanMaximum":"The number of attachments exceed the maximum number allowed. Upload up to 20 attachments.","loc_admin_markdownEditor_attachment_platformInvalid":"Platform is not supported.","loc_admin_markdownEditor_attachment_internalServerError":"Internal server error.","loc_admin_markdownEditor_attachment_unauthorizedRequest":"Unauthorized request. Please make sure you are using the correct credential.","loc_admin_markdownEditor_blockquote":"Blockquote","loc_admin_markdownEditor_bold":"Bold","loc_admin_markdownEditor_bulletedList":"Bulleted list","loc_admin_markdownEditor_caution":"Caution","loc_admin_markdownEditor_cancel":"Cancel","loc_admin_markdownEditor_code":"Code","loc_admin_markdownEditor_codeBlock":"Code block","loc_admin_markdownEditor_codeBlockLanguagePlaceholder":"Select development language","loc_admin_markdownEditor_codeBlockLanguage":"Select development language","loc_admin_markdownEditor_codeBlockLanguageEdit":"Edit development language","loc_admin_markdownEditor_complex":"Complex","loc_admin_markdownEditor_content":"Content","loc_admin_markdownEditor_disabled":"Disabled","loc_admin_markdownEditor_displayText":"Display text","loc_admin_markdownEditor_devLangsInputPlaceholder":"Search for a language","loc_admin_markdownEditor_file":"File","loc_admin_markdownEditor_fileUpload":", drag & drop, or paste a file.","loc_admin_markdownEditor_fileUploadFailedMessage":"File upload failed. Please try again.","loc_admin_markdownEditor_headings":"Headings","loc_admin_markdownEditor_heading":"Heading {number}","loc_admin_markdownEditor_help":"Help","loc_admin_markdownEditor_horizontalRule":"Horizontal rule","loc_admin_markdownEditor_icon":"Icon","loc_admin_markdownEditor_image":"Image","loc_admin_markdownEditor_imageAlt":"User's image","loc_admin_markdownEditor_imageUpload":", drag & drop, or paste an image","loc_admin_markdownEditor_imageUploadFailedMessage":"Image upload failed. Please try again.","loc_admin_markdownEditor_imageBorder":"Image border","loc_admin_markdownEditor_imageDescription":"Image description","loc_admin_markdownEditor_imageDescriptionAltText":"Image description (alt text)","loc_admin_markdownEditor_imageDescriptionAltTextPlaceholder":"Enter a description (alt text) for the image","loc_admin_markdownEditor_imageHasALightbox":"Image has a lightbox","loc_admin_markdownEditor_imageLightbox":"Image lightbox","loc_admin_markdownEditor_imageLocScope":"Image loc-scope","loc_admin_markdownEditor_imageSource":"Image source","loc_admin_markdownEditor_important":"Important","loc_admin_markdownEditor_inlineCode":"Inline Code","loc_admin_markdownEditor_insertCodeBlock":"Insert code block","loc_admin_markdownEditor_insertFile":"Insert file","loc_admin_markdownEditor_insertHorizontalRule":"Insert horizontal rule","loc_admin_markdownEditor_insertImage":"Insert image","loc_admin_markdownEditor_insertLink":"Insert link","loc_admin_markdownEditor_insertTable":"Insert table","loc_admin_markdownEditor_italics":"Italics","loc_admin_markdownEditor_link":"Link","loc_admin_markdownEditor_markdown":"Markdown","loc_admin_markdownEditor_noMatches":"We couldn't find any matches.","loc_admin_markdownEditor_note":"Note","loc_admin_markdownEditor_numberedList":"Numbered list","loc_admin_markdownEditor_pleaseSelectImageType":"Please select image type","loc_admin_markdownEditor_quote":"Quote","loc_admin_markdownEditor_redo":"Redo","loc_admin_markdownEditor_remove":"Remove","loc_admin_markdownEditor_removeLink":"Remove link","loc_admin_markdownEditor_save":"Save","loc_admin_markdownEditor_saveNewLink":"Save Link","loc_admin_markdownEditor_selectImageTypePlaceholder":"Select an image type","loc_admin_markdownEditor_showCountResults":"Showing {count} results","loc_admin_markdownEditor_strikethrough":"Strikethrough","loc_admin_markdownEditor_suggestions":"Suggestions","loc_admin_markdownEditor_table":"Table","loc_admin_markdownEditor_table_column":"Column","loc_admin_markdownEditor_table_editTable":"Edit table","loc_admin_markdownEditor_table_insertColumnAfter":"Insert column after","loc_admin_markdownEditor_table_insertColumnBefore":"Insert column before","loc_admin_markdownEditor_table_insertRowBefore":"Insert row after","loc_admin_markdownEditor_table_insertRowAfter":"Insert row before","loc_admin_markdownEditor_table_removeColumn":"Remove column","loc_admin_markdownEditor_table_row":"Row","loc_admin_markdownEditor_table_removeRow":"Remove row","loc_admin_markdownEditor_tip":"Tip","loc_admin_markdownEditor_toggleMarkdownEditing":"Toggle Markdown editing","loc_admin_markdownEditor_typeHere":"Type here","loc_admin_markdownEditor_undo":"Undo","loc_admin_markdownEditor_validations":"Validation","loc_admin_markdownEditor_validations_altTextEndWithPeriod":"Alt text should end with a period.","loc_admin_markdownEditor_validations_altTextStartWithUppercaseLetter":"Alt text should start with an uppercase letter.","loc_admin_markdownEditor_validations_altTextTooLong":"Alt text too long. The max is 150 characters, including spaces.","loc_admin_markdownEditor_validations_imageWidthTooLarge":"invalid file width","loc_admin_markdownEditor_validations_imageWidthTooLargeMessage":"Image too large. Resize to a max of 1200 pixels on each side.","loc_admin_markdownEditor_validations_imageCorrupted":"image corrupted","loc_admin_markdownEditor_validations_imageCorruptedMessage":"Image corrupted or it is not a valid image","loc_admin_markdownEditor_validations_imageInvalidPosition":"invalid image position","loc_admin_markdownEditor_validations_imageInvalidPositionMessage":"Inline images aren't supported. Add your image on a new line.","loc_admin_markdownEditor_validations_attachmentTooLarge":"attachment too large","loc_admin_markdownEditor_validations_attachmentInvalidName":"attachment invalid name","loc_admin_markdownEditor_validations_attachmentInvalidNameMessage":"Attachment upload error. Invalid characters in attachment name. Only letters, numbers, and hyphens (-) are allowed.","loc_admin_markdownEditor_validations_attachmentInvalidExtension":"Invalid attachment extension","loc_admin_markdownEditor_validations_attachmentTooSmall":"attachment too small","loc_admin_markdownEditor_validations_qnaAttachmentTooSmallMessage":"Attachment upload error. {filename} is too small to upload (less than {minSize} byte).","loc_admin_markdownEditor_validations_multipleAttachments":"Multiple attachments","loc_admin_markdownEditor_validations_qnaMultipleAttachmentsMessage":"Attachment upload error. You are adding {filecount} attachments and the maximum allowed is {maxCount}. Some attachments were not uploaded.","loc_admin_markdownEditor_validations_qnaAttachmentTooLargeMessage":"Attachment upload error. {filename} is too large to upload (more than {maxSize} MB).","loc_admin_markdownEditor_validations_qnaAttachmentInvalidExtensionMessage":"Attachment upload error. {filename} has an invalid extension. Valid extensions are {validExtensions}.","loc_admin_markdownEditor_validations_qnaAttachmentInvalidNameMessage":"Attachment upload error. {filename} has an invalid character in Unix and Windows system, for other limitations, please go to websites to check: https://kb.acronis.com/content/39790, http://en.wikipedia.org/wiki/C0_and_C1_control_codes.","loc_admin_markdownEditor_viewMarkdown":"View Markdown","loc_admin_markdownEditor_viewRichText":"View rich text","loc_admin_markdownEditor_warning":"Warning"}" placeHolder="Use answers to provide solutions to the user's question." isrtl=false > </docs-markdown-editor> <textarea hidden id="body-2119458-answer" aria-label="Answer" class="textarea" name="body" rows="1" data-expanded-rows="5" placeholder="Add some details..." minlength="10" required ></textarea> <input id="attachment-count" aria-label="attachmentCount" class="attachment-input input" maxCount="20" hidden data-skip-validation /> <div aria-live="polite" class="qna-saved-draft has-text-left font-size-xs"></div> </div> </div> <div class="control"> <div class="buttons"> <button type="submit" data-bi-name="answer-submit" class="button button-primary button-filled " > Post your answer </button> <button data-modal-type="qna-discard-draft" class="button button-clear" data-bi-name="answer-discard-draft" data-question-id="2119458" type="button" hidden="true" > <span class="icon" aria-hidden="true"> <span class="docon docon-delete"></span> </span> <span>Discard draft</span> </button> </div> </div> </form> </div> </div> </div> <aside id="ms--additional-resources-mobile" aria-label="Additional resources" class="display-none-tablet display-none-print" data-test-id="additional-resources-mobile" > <hr class="hr" hidden /> <h2 id="ms--additional-resources-mobile-heading" class="title is-3" hidden> Additional resources </h2> <section id="right-rail-recommendations-mobile" data-bi-name="recommendations" data-test-id="right-rail-recommendations-mobile" hidden ></section> <section id="right-rail-training-mobile" data-bi-name="learning-resources-card" hidden ></section> <section id="right-rail-events-mobile" data-bi-name="events-card" hidden></section> </aside> </div> </main> <aside id="layout-body-aside" class="layout-body-aside " data-bi-name="aside" > <div id="affixed-right-container" class="layout-padding padding-block-md"> <article class="display-none display-block-tablet overflow-hidden margin-top-none"> <h3 class="title is-6 margin-bottom-none">Question activity</h3> <div class=" padding-top-xs margin-top-xxs"> <a class="not-authenticated button button-primary button-block button-filled docs-sign-in" href="#" > Sign in to follow questions and users </a> <form action="/api/profiles/follow/question/2119458?locale=en-us" method="POST" new novalidate hidden data-follow-question-id=2119458 class="authenticated " > <form-behavior navigation="reload" navigation-href="empty" header-content-type="application/json" header-X-DocsAuth="cookie" new ></form-behavior> <button class=" button button-primary button-block " data-bi-name=follow-question type="submit" > Follow question </button> </form> </div> </article> <div class="display-none display-block-tablet margin-top-lg" data-test-id="additional-resources"> <h3 id="ms--additional-resources-heading" class="title is-6" hidden> Additional resources </h3> <section id="right-rail-events" data-bi-name="event-cards" hidden></section> <section id="right-rail-training" data-bi-name="learning-resources-cards"></section> <section id="right-rail-recommendations" data-bi-name="recommendations" data-test-id="right-rail-recommendations" ></section> </div> </div> </aside> </body> <div class="layout-body-footer " data-bi-name="layout-footer"> <footer id="footer" data-test-id="footer" data-bi-name="footer" class="footer-layout has-padding has-default-focus border-top uhf-container" role="contentinfo" > <div class="display-flex gap-xs flex-wrap-wrap is-full-height padding-right-lg-desktop"> <a data-mscc-ic="false" href="#" data-bi-name="select-locale" class="locale-selector-link flex-shrink-0 button button-sm button-clear external-link-indicator" id="" title="" ><span class="icon" aria-hidden="true" ><span class="docon docon-world"></span></span ><span class="local-selector-link-text">en-us</span></a > <div class="ccpa-privacy-link" data-ccpa-privacy-link hidden> <a data-mscc-ic="false" href="https://aka.ms/yourcaliforniaprivacychoices" data-bi-name="your-privacy-choices" class="button button-sm button-clear flex-shrink-0 external-link-indicator" id="" title="" > <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 30 14" xml:space="preserve" height="16" width="43" aria-hidden="true" focusable="false" > <path d="M7.4 12.8h6.8l3.1-11.6H7.4C4.2 1.2 1.6 3.8 1.6 7s2.6 5.8 5.8 5.8z" style="fill-rule:evenodd;clip-rule:evenodd;fill:#fff" ></path> <path d="M22.6 0H7.4c-3.9 0-7 3.1-7 7s3.1 7 7 7h15.2c3.9 0 7-3.1 7-7s-3.2-7-7-7zm-21 7c0-3.2 2.6-5.8 5.8-5.8h9.9l-3.1 11.6H7.4c-3.2 0-5.8-2.6-5.8-5.8z" style="fill-rule:evenodd;clip-rule:evenodd;fill:#06f" ></path> <path d="M24.6 4c.2.2.2.6 0 .8L22.5 7l2.2 2.2c.2.2.2.6 0 .8-.2.2-.6.2-.8 0l-2.2-2.2-2.2 2.2c-.2.2-.6.2-.8 0-.2-.2-.2-.6 0-.8L20.8 7l-2.2-2.2c-.2-.2-.2-.6 0-.8.2-.2.6-.2.8 0l2.2 2.2L23.8 4c.2-.2.6-.2.8 0z" style="fill:#fff" ></path> <path d="M12.7 4.1c.2.2.3.6.1.8L8.6 9.8c-.1.1-.2.2-.3.2-.2.1-.5.1-.7-.1L5.4 7.7c-.2-.2-.2-.6 0-.8.2-.2.6-.2.8 0L8 8.6l3.8-4.5c.2-.2.6-.2.9 0z" style="fill:#06f" ></path> </svg> <span>Your Privacy Choices</span></a > </div> <div class="flex-shrink-0"> <div class="dropdown has-caret-up"> <button data-test-id="theme-selector-button" class="dropdown-trigger button button-clear button-sm has-inner-focus theme-dropdown-trigger" aria-controls="{{ themeMenuId }}" aria-expanded="false" title="Theme" data-bi-name="theme" > <span class="icon"> <span class="docon docon-sun" aria-hidden="true"></span> </span> <span>Theme</span> </button> <div class="dropdown-menu" id="{{ themeMenuId }}" role="menu"> <ul class="theme-selector padding-xxs" data-test-id="theme-dropdown-menu"> <li class="theme display-block"> <button class="button button-clear button-sm theme-control button-block justify-content-flex-start" data-theme-to="light" > <span class="theme-light margin-right-xxs"> <span class="theme-selector-icon border display-inline-block has-body-background" aria-hidden="true" > <svg class="svg" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 22 14"> <rect width="22" height="14" class="has-fill-body-background" /> <rect x="5" y="5" width="12" height="4" class="has-fill-secondary" /> <rect x="5" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="8" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="11" y="2" width="3" height="1" class="has-fill-secondary" /> <rect x="1" y="1" width="2" height="2" class="has-fill-secondary" /> <rect x="5" y="10" width="7" height="2" rx="0.3" class="has-fill-primary" /> <rect x="19" y="1" width="2" height="2" rx="1" class="has-fill-secondary" /> </svg> </span> </span> <span role="menuitem"> Light </span> </button> </li> <li class="theme display-block"> <button class="button button-clear button-sm theme-control button-block justify-content-flex-start" data-theme-to="dark" > <span class="theme-dark margin-right-xxs"> <span class="border theme-selector-icon display-inline-block has-body-background" aria-hidden="true" > <svg class="svg" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 22 14"> <rect width="22" height="14" class="has-fill-body-background" /> <rect x="5" y="5" width="12" height="4" class="has-fill-secondary" /> <rect x="5" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="8" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="11" y="2" width="3" height="1" class="has-fill-secondary" /> <rect x="1" y="1" width="2" height="2" class="has-fill-secondary" /> <rect x="5" y="10" width="7" height="2" rx="0.3" class="has-fill-primary" /> <rect x="19" y="1" width="2" height="2" rx="1" class="has-fill-secondary" /> </svg> </span> </span> <span role="menuitem"> Dark </span> </button> </li> <li class="theme display-block"> <button class="button button-clear button-sm theme-control button-block justify-content-flex-start" data-theme-to="high-contrast" > <span class="theme-high-contrast margin-right-xxs"> <span class="border theme-selector-icon display-inline-block has-body-background" aria-hidden="true" > <svg class="svg" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 22 14"> <rect width="22" height="14" class="has-fill-body-background" /> <rect x="5" y="5" width="12" height="4" class="has-fill-secondary" /> <rect x="5" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="8" y="2" width="2" height="1" class="has-fill-secondary" /> <rect x="11" y="2" width="3" height="1" class="has-fill-secondary" /> <rect x="1" y="1" width="2" height="2" class="has-fill-secondary" /> <rect x="5" y="10" width="7" height="2" rx="0.3" class="has-fill-primary" /> <rect x="19" y="1" width="2" height="2" rx="1" class="has-fill-secondary" /> </svg> </span> </span> <span role="menuitem"> High contrast </span> </button> </li> </ul> </div> </div> </div> </div> <ul class="links" data-bi-name="footerlinks"> <li class="manage-cookies-holder" hidden=""></li> <li> <a data-mscc-ic="false" href="https://learn.microsoft.com/en-us/previous-versions/" data-bi-name="archivelink" class=" external-link-indicator" id="" title="" >Previous Versions</a > </li> <li> <a data-mscc-ic="false" href="https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog" data-bi-name="bloglink" class=" external-link-indicator" id="" title="" >Blog</a > </li> <li> <a data-mscc-ic="false" href="https://learn.microsoft.com/en-us/contribute" data-bi-name="contributorGuide" class=" external-link-indicator" id="" title="" >Contribute</a > </li><li> <a data-mscc-ic="false" href="https://go.microsoft.com/fwlink/?LinkId=521839" data-bi-name="privacy" class=" external-link-indicator" id="" title="" >Privacy</a > </li><li> <a data-mscc-ic="false" href="https://learn.microsoft.com/en-us/legal/termsofuse" data-bi-name="termsofuse" class=" external-link-indicator" id="" title="" >Terms of Use</a > </li><li> <a data-mscc-ic="false" href="https://aka.ms/msftqacodeconduct" data-bi-name="codeofconduct" class=" external-link-indicator" id="" title="" >Code of Conduct</a > </li><li> <a data-mscc-ic="false" href="https://www.microsoft.com/legal/intellectualproperty/Trademarks/" data-bi-name="trademarks" class=" external-link-indicator" id="" title="" >Trademarks</a > </li> <li>© Microsoft 2025</li> </ul> </footer> </footer> </html>

CINXE.COM

Possibity of upgrade and migration from SQL 2014 to SQL 2022 - Microsoft Q&A