Reinstall SQL Server 2005

Hi all,

I want to remove SQL Server 2005 sp2, so I need to reinstall SQL Server 2005. What steps I need to take before remove the SQL Server 2005. Because I don't want to loss any data on the Database Server, Analysis Servers, and Reporting Server.

Thanks,

Why do you want to uninstall SP2? It might be easier to solve the issue you are having with SP2 than completely reinstalling SQL Server 2005.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Hi WesleyB

My problem is the inscope funtion in Reporting Service, and it is the know issue in SP2. And I don't like there workaround solution, so I need to roll back to SP1.

Thanks,

|||

You can uninstall service pack 2 after which you best install the previous fixes that were applied.

Take a backup of your databases before you try this however.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com