Friday, March 30, 2012

Running both 2000 & 2005 ?

Is it possible to run SqlServer 2000 & 2005 on the same Server? We're
only a small company with 1 server, and we'd like to try 2005 without
losing access to our 2000 databases.Jon
Yes , it is.
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
> Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
> a small company with 1 server, and we'd like to try 2005 without losing
> access to our 2000 databases.|||Hi
Yes, they are supported side-by-side. The 2nd instance has to be a named
instance "servername\instancename", but otherwise, the 2 reside happily
together.
Don't forget, since you have 2 DB engines on 1 server, they have to share
resources, including RAM, so don't expect both to run at 100% if you are
beating both hard.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
> Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
> a small company with 1 server, and we'd like to try 2005 without losing
> access to our 2000 databases.|||Thank-you Mike & Uri for your prompt (and unexpected!) replies.
Mike Epprecht (SQL MVP) wrote:
> Hi
> Yes, they are supported side-by-side. The 2nd instance has to be a named
> instance "servername\instancename", but otherwise, the 2 reside happily
> together.
> Don't forget, since you have 2 DB engines on 1 server, they have to share
> resources, including RAM, so don't expect both to run at 100% if you are
> beating both hard.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
> message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
>>Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
>>a small company with 1 server, and we'd like to try 2005 without losing
>>access to our 2000 databases.
>
>

No comments:

Post a Comment