March 11, 2008 at 2:16 pm
I am looking to consolidate multiple instances onto one database server.
Can you install both SQL Server 2000 and SQL Server 2005 (is it even supported or recommended) of SQL Server on one server?
Also, in test I've created multiple instances in SQL 2005 and have applied service packs to some instances and not to others. Is this a safe practice in a production environment. When you apply a service pack to just one instance, does it update files that may be used by all of the instances.
I've been trying, unsuccessfully, to get a definitive answer to this for quite a while now.
Thanks in advance.
Jenn
March 11, 2008 at 2:59 pm
Yes you can run SQL 2000 and SQL 2005 on the same server. One will have to ba named instance.
You can also run different SP levels on one server using named instances.
I think that with the advances in virtualization you are more likely to see the multiple instances to be installed in VM's instead of as Named instances, especially when running at different SP levels.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply