x

SQL Server 2008 in-place upgrade - Remove SQL Server 2005 components

The following SQL Server 2005 components are installed after SQL Server 2008 in-place upgrade:
Microsoft SQL Server 2005:
Microsoft SQL Server 2005 Backward compatibilty:
Microsoft SQL Server Native Client:
Microsoft SQL Server Setup Support Files (English):

According to the "SQL Server 2008 Upgrade Technical Reference Guide":

Setup removes the legacy executables and support files in addition to the legacy SQL Server 2000 tools. SQL Server 2005 tools are not removed.


I need to make room on the server so I'd like to know if I remove these components.

more ▼

asked Jan 21 '10 at 05:26 PM in Default

William gravatar image

William
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Another solution could be to baclup your databases, script out logins with pwds, jobs, SSIS packets and so on. Then you can completely remove SQL 2005 and restore your backups, jobs, logins and other objects. But that is more work, and demands more care so that you do not loose anything

more ▼

answered Jan 25 '10 at 05:39 AM

Steinar gravatar image

Steinar
1.7k 3 4 6

(comments are locked)
10|1200 characters needed characters left

I would say that the risk of removing them would far outweigh the benefit of the space you'll get back - they're not exactly huge components, after all.

You'd probably get more space back by deleting temp files, anyway...

more ▼

answered Jan 21 '10 at 05:53 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

(comments are locked)
10|1200 characters needed characters left

Hi,

For the first time, today, I upgraded (in-place) SQL Server 2005 standard edition to SQL Server 2008 enterprise edition with SP1 + Cumulative hotfixes.

I observed that SQL Server 2005 tools along with Visual Studio 2005 are still existing like in the machine along with SQL Server 2008 tools and Visual Studio 2008. I'm not sure if I have upgraded SQL 2005 to 2008 properly or not. I didn't get any errors and all went well.

I tried to google a lot about post upgrade but I didn't find anything.

Could anyone please let me know if I can ignore those tools or do I need to uninstall?

Please let me know if you need any more information.

Thanks, - Manohar

more ▼

answered May 05 '10 at 07:33 PM

Manohar gravatar image

Manohar
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x68

asked: Jan 21 '10 at 05:26 PM

Seen: 2935 times

Last Updated: Jan 21 '10 at 05:26 PM