Saturday, February 25, 2012

can SQL 2000 still be used after the upgrade?

Hello:
Let's say that you have SQL Server 2000 SP3 on a server, and let's say that
you upgrade SQL 2000 to 2005.
It's a long story as to why I ask, but is it possible after the upgrade to
utilize SQL 2000 still? Or, after you perform such an upgrade, should you
stay away from SQL 2000?
Can SQL 2000 and SQL 2005 co-exist on the same server like this? Or, is SQL
2000 "dead" after such an upgrade?
Generally, after I upgrade a product of any kind, I don't mess with the
older product afterward. That's why I ask.
Thanks!
childofthe1980s
You can have both SQL 2000 and SQL 2005 on the same box, but SQL 2000 must
be installed before SQL 2005. In your case, you upgraded, so there is only
one instance of SQL Server on your machine.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:A185952C-BB25-44E9-B5B9-00C3B5E0C2C6@.microsoft.com...
Hello:
Let's say that you have SQL Server 2000 SP3 on a server, and let's say that
you upgrade SQL 2000 to 2005.
It's a long story as to why I ask, but is it possible after the upgrade to
utilize SQL 2000 still? Or, after you perform such an upgrade, should you
stay away from SQL 2000?
Can SQL 2000 and SQL 2005 co-exist on the same server like this? Or, is SQL
2000 "dead" after such an upgrade?
Generally, after I upgrade a product of any kind, I don't mess with the
older product afterward. That's why I ask.
Thanks!
childofthe1980s

No comments:

Post a Comment