uninstalling sql 2005 after installing sql 2008

Question

I installed SQl 2008 and migrated my database and logins across to my new install. Microsoft win with the migration btw. But now i want to uninstall sql 2005. Is this recommended? Because the full installion is still there and i prefer to just have the sql 2008 management console on the server. Any help would be appriciated. 

Answer 1

Hi Richard,
The general recommendation is to use Add/Remove Programs from Control Panel.  There's more information in this Books Online topic: http://msdn.microsoft.com/en-us/library/ms143412.aspx.

Kind Regards,

Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

The think is the installation did not remove the instance of sql 2005 from the server. I want to remove it but not sure what the consequences are. Do you know?

Answer 3

Hi Richard,
When you say, "The think is the installation did not remove the instance of sql 2005 from the server", do you mean that you expect the installation of SQL Server 2008 to replace (or remove) the instance of SQL Server 2005?   SQL Server 2008 is designed to work side-by-side with an installation of SQL Server 2005, so no attempt is made during installation to remove the older version.   If you meant something else, please elaborate.

Do answer your other question, if you have successfully migrated your database and users, then no, there are no consequences to removing the SQL Server 2005 version.

Kind Regards,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

Hi Gail,
Thanks for the information.