Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

After upgrading a SQL Server 2008 instance to SQL Server 2012 (in-place upgrade), there appears to be numerous 2008 instance components (namely the 2008 SSMS in start menu, in add/remove programs Microsoft SQL Server 2008 and other items in add/remove programs relating to SQL Server 2008).

How to remove all traces of SQL Server 2008 such that the database is a clean 2012 instance?

share|improve this question
You can remove the older components related to sql 2008 from the add/remove program. Ideally, I would prefer a side by side migration - installing sql 2012 and then performing backup/restore of 2008 databases to 2012. Also, refer to post upgrade steps. – Kin Jan 6 '14 at 16:21
Thanks Kin but the application requires use of the default instance, and my understanding is that the instance cannot be changed after install. Unless there is another way around this? – tubgirl Jan 7 '14 at 1:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.