Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Salesforce
  3. Question
Salesforce

How to upgrade SQL server 2008 to 2012?

Asked by Murakami Tanaka Aug 23, 2021 1.7K views 1 answer
Share

About this question

I have upgraded my SQL Server 2008 R2 Enterprise edition to SQL Server 2012. Even after the upgrade I can see & use SQL Server 2008 R2 instance without any issue. Did my upgrade go fine?

I can open default instances both from SQL Server 2008 and 2012. Also, I have updated the compatibility level of all databases to 110.

After in-place upgrade

screenshot

Edit - version

After running

SELECT @@Version

SQL Server 2012

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

SQL Server 2008 R2

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest Salesforce Blogs

Guides, tips and career advice on Salesforce from JanBask experts.