SQL Upgrade

I upgraded SCCM database from SQL 2012 to SQL 2014.  after upgradation now I have following folders

%program files%\MSAS11.MSSQLSERVER and MSAS12.MSSQLSERVER
%program files%\MSRS11.MSSQLSERVER and MSRS12.MSSQLSERVER
%program files%\MSSQL11.MSSQLSERVER and MSSQL12.MSSQLSERVER

all folders are 11 and 12 is there and the database in 11 folder only, is this normal?
asnageshAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
yes.an upgrade does not move the db files.
you may move db files, however, if needed:
https://msdn.microsoft.com/en-us/library/ms189133.aspx
0
 
asnageshAuthor Commented:
as long as it is not an error, I do not need to move the files. I observed one more thing that the SQL Management Studio still shows 2012, Do I need to install separately?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, the sql client tools are different from the scm tools
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.