September 25, 2008 at 8:36 am
I have a SQL Server 2000 Production Server and a SQL Server 2000 Test Server. I have a SQL Server 2005 Production Server but I do not have a SQL Server 2005 Test Server. I would like to restore my SQL Server 2005 Production Backups (to verify the backups). I was wondering if I could install SQL Server 2005 Software on my SQL Server 2000 Machine. Would the SQL Server 2005 Install be done into a separate 2005 Directory Structure? (I do not want to corrupt my existing SQL Server 2000 Software.) Also, if I am able to install SQL Server 2005 on the SQL Server 2000 Machine, would I be able to uninstall SQL Server 2005 without affecting the SQL Server 2000 Install?
Our SQL Server 2000 Environment:
Windows 2003 Server Rel 2 Standard Edition SP2
SQL Server 2000 Standard Edition SP3
Our SQL Server 2005 Environment:
Windows 2003 Server Rel 2 Enterprise Edition SP2
SQL Server 2005 Enterprise Edition SP2
Thanks in advance, Kevin
September 25, 2008 at 8:45 am
I am running 3 instances on a test machine.
2 named instances of SQL 2005 and 1 instance of SQL 2000.
2 instances of SQL 2005 are 64 bit, while Standard 2000 (of course) is 32.
You can install and uninstall instances without hurting the rest of installations.
September 25, 2008 at 8:49 am
You can install SQL server 2005 on the same machine as a SQL server 2000 BUT i believe you may have to use a named instance... for the SQL 2005 install (not completely sure though.)
The fact that your SQL 2000 instance is installed and working correctly on test should mean installing and running SQL 2005 is straight forward. You should also be able to remove the sql 2005 install if you wish.
This link may help
http://www.myitforum.com/articles/18/view.asp?id=9540
Gethyn Elliswww.gethynellis.com
September 25, 2008 at 9:06 am
Ellis RemoteDBA (9/25/2008)
The fact that your SQL 2000 instance is installed and working correctly on test should mean installing and running SQL 2005 is straight forward. You should also be able to remove the sql 2005 install if you wish.
This link may help
http://www.myitforum.com/articles/18/view.asp?id=9540%5B/quote%5D
Correct - you can only run one "default" instance per machine, regardless of versions. So- you'd need to set up 2005 as a named instance.
Otherwise you should not have any issues with them stepping on each other.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply