September 14, 2009 at 1:51 pm
We want to install SQL Server 2008 as the default instance on a server. We then need to install SQL Server 2000 as a named instance. These are brand new, clean installs.
The scenario is this. We have SQL 2000 databases that we want to migrate to sql 2008, however, we need keep them as sql server 2000 databases until we are ready to migrate them.
We have SQL Server 2008 databases that we want top move to the new server as well but due to appplication requirements, the SQL 2008 installation must be the default.
The question is: Which instance must be the default? Can we install SQL 2008 as the default and then SQL 2000 as a named instance and still run both versions?
Thx folks.
September 14, 2009 at 4:09 pm
Yes you can, but you need to install SQL Server 2000 first (and apply all service packs/patches), then you can install SQL Server 2008 as the default instance. If you install SQL Server 2000 after 2008 it will cause problems with connectivity.
Also, you should review the following article: http://support.microsoft.com/kb/2000255
Edited: Changed references to 2005 to 2008 - same issues apply to either.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 14, 2009 at 4:41 pm
Jeffery,
Thank you. That's what I thought, but couldn't find supporting documentation.
Thank you for providing the KB article....
Fairbanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply