title: How to upgrade SQL Server 2012 to 2019?
body: <p>I have a database backup that I cannot restore, because it was created with a newer version of SQL Server, error below:</p>
  <p><a href="https://i.stack.imgur.com/DW4ds.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DW4ds.png" alt="enter image description here" /></a></p>
  <p>Here's the info I get in SSMS under Help &gt; About:</p>
  <pre><code>Microsoft SQL Server Management Studio     11.0.7507.2
  Microsoft Analysis Services Client Tools   11.0.7507.2
  Microsoft Data Access Components (MDAC)    10.0.19041.1
  Microsoft MSXML                            3.0 6.0 
  Microsoft Internet Explorer                9.11.19041.0
  Microsoft .NET Framework                   4.0.30319.42000
  Operating System                           6.3.19044
  </code></pre>
  <p>What are the steps to take to upgrade my SQL Server and SSMS to 2019? This is a local environment on Windows 10.</p>