New Instance on SQL 2000 SP 4

Hi,
I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP 1. I
want to install a named instance (this is a development environment). As
far as I know, I will need start the install of the named instance from the
SQL 2000 RTM install file set.
What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need to
re-patch them all to SP4? Will the new instance be RTM or SP4? Does
Microsoft have a SQL 2000 SP 4 install image?
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgThe named instance will be RTM. You will need to patch the named instance
to SP4, but you should not need to do anything to the existing instance.
There is not a SQL Server 2000 SP4 install image to my knowledge, such as
there is with operating systems.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/
> Hi,
> I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP
> 1. I want to install a named instance (this is a development
> environment). As far as I know, I will need start the install of the
> named instance from the SQL 2000 RTM install file set.
> What does this do to my existing SQL 2000 SP 4 instance(s)? Do I need
> to re-patch them all to SP4? Will the new instance be RTM or SP4?
> Does Microsoft have a SQL 2000 SP 4 install image?
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org