Upgrade sql 2005 to sql 2008 r2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Upgrade sql 2005 to sql 2008 r2

Upgrade sql 2005 to sql 2008 r2

Rate Topic

Display Mode

Topic Options

Author

Message

msocp

Posted Monday, February 04, 2013 4:57 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:10 AM
Points: 20, Visits: 223

successfully done upgrade sql 2005 to sql 2008 r2, now the same server both database is running i want to remove the sql 2005 from the window server.
how to remove the sql server 2005 DB.

Thanks & Regards
Shafiq

Post #1415234

SQL Pizza

Posted Monday, February 04, 2013 5:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

Did you choose a different installation directory?

Did you try to uninstall it via Programs and features? (Start -> Control Panel -> Programs and Features -> SQL Server 2005 -> uninstall)

Greetz sqlpizza

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1415238

msocp

Posted Monday, February 04, 2013 5:35 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:10 AM
Points: 20, Visits: 223

i did not try to uninstall from control panel, upgrade done on the same directory. successfully running both sql sever DB instance.now i want to remove sql server 2005.
thanks for given suggestion.

Post #1415245

SQL Pizza

Posted Monday, February 04, 2013 5:45 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

If you installed explicitly in the same directy, having same instance name, the best thing would be to just disable the 2005 services.

If anybody has a diffrent opinion bout this. Please correct me!

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1415249