March 6, 2011 at 11:54 am
Hello Everyone,
Can you please tell me whether it is possible to install SqlServer 2008 on top of existing SQLServer 2005 in my machine. Please help me on this, as it is of my highest priority.
Thanks,
Sandeep
March 6, 2011 at 1:53 pm
It is easy to install both instances so that they run side-by-side. Just don't select n upgrade option and specify a different instance name.
If you want to upgrade the existing 2005 so that it becomes 2008, technically, you can do this easily enough as well. Read about it here: http://msdn.microsoft.com/en-us/library/ms144267.aspx.
If I were to do an in place upgrade, I would prefer to do a complete uninstall after saving off the server settings, installing the new version and reapplying the settings. Why? Call me old school, but I also won't in place upgrade XP to vista or vista to windows 7 either (or WFW 3.11 to windows 95), even though microsoft swears it'll work with no problems, and I have had occasional success. I've just found it always worth the time to rebuild it - especially for a critical production system that must be stable.
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
March 6, 2011 at 10:00 pm
Thanks a lot Jim, your information is helping me a lot.
March 7, 2011 at 6:22 am
You can do this, but it is not recommended that you add SQL 2008 to a production server that is already in use with SQL 2005. If you are building a new server to host both versions then you can test that everything is OK before you go live, but on a server already in production you put your live environment at risk by adding SQL 2008.
A number of people have had problems with adding SQL Server 2008 to a machine that is already running SQL 2005. The main problem area is adding the .Net 3.5 SP1 component - sometimes this simply will not install. Ther is a Microsoft tool that is designed to fix this problem by zapping registry entries, but it does not work all of the time. At my place maybe 10% of developer workstations that ran W2003 and SQL 2005 needed to be reformatted and have a new Windows install done to get both SQL 2005 and SQL 2008 working.
Your experience may be different, but if you are planning an in-place upgrade of a production box then your planning needs to include what you would do if any part of the upgrade fails.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 7, 2011 at 10:16 pm
But, mine is a personal one, and moreover i dove have both versions installed properly in my machine, as of now i don't have any problems with them...
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply