2

We upgraded a default instance from SQL Server 2005 to 2012 today. But Components of SQL Server 2005 are still on the server. These includes the MSQL1. folder (it has all the data and log files), Mgmt Studio and configuration manager. The instance now shows it is 2012 version. I am hesitant to uninstall SQL Server 2005 as it may cause problems. Any thoughts? Has anyone come to experience this? Thanks in advance

Improve this question

1 Answer 1

Reset to default
1

Any uninstall of SQL Server will not delete the data or log directories used by the particular version.

The reason your data and log files stayed in the same spot is because you did an inplace upgrade. It will not move the databases to the "new" folders SQL Server 2012 would create (eg. "..\MSSQL11.MSSQLSERVER\DATA").

The only issue you could hit when removing SQL Server is with the shared tools (e.g. SSMS, etc.), but since 2012 changed to using full VS it should not cause any issues.

Improve this answer
2
  • Thanks Shawn. Appreciate it. If the files will remain intact, i guess it is a non-issue. If I leave 2005 in place, do you know if the company will pay the annual license fee for both 2005 and 2012?
    – Pol
    Commented Jun 15, 2016 at 20:57
  • I can't answer the license questions, you would need to confirm that with your license rep for Microsoft or legal department.
    – user507
    Commented Jun 15, 2016 at 22:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.