Both SQL 2000 and SQL 2005 on same production server

Hello,

We have a vendor supplied application that only supports SQL 2000 (for at least another 6 months.) Our team also wants to use SQL 2005 for some of the native XML benefits with custom code.

Several of our team wants to install both versions of SQL (2k, 2005) on the same server even in our production environment. I am wary of supporting this for a high availability application, and am concerned that the next service pack or hotfix could cause problems.

1) Though I have read it is supported, are any Fortune 100 type companies using this configuration for high availability applications?

2) Does SQL's fundamental capability to support multiple instances make this more trivial than I am thinking?

3) Would anyone have points that would support the conservative approach against this without just sounding paranoid?

Thank You,

Mike

You can do that but you need to implement high availability on the server level using approaces like clustering, etc. We are doing that in our environment, of course, using clustering for high availability (MSCS, Veritas Cluster, etc.)

Born Again Spamer

In aus.cars stewart_connor@.netzero.com wrote:
> If you are going to respond to these at least shorten the subject line
> please
[snip quoting of a shite post that never even got to my server]
If you're going to respond to this shite, snip anything irrelevant
(ie the whole lot) and then we won't know that you're a fecking
stupid top-poster.
Athol
<http://cust.idl.com.au/athol> Linux Registered User # 254000
The state of Australia's infrastructure is a national disgrace.
I'm a Libran Engineer. I don't argue, I discuss.If you are going to reply to posts like this, please go somewhere else. We
do NOT need to perpetuate such things, regardless of how they make you feel.
This is a DATABASE PROGRAMMING forum.
----
Louis Davidson - drsql@.hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design -
http://www.apress.com/book/bookDisplay.html?bID=266
Blog - http://spaces.msn.com/members/drsql/
Note: Please reply to the newsgroups only unless you are interested in
consulting services. All other replies may be ignored :)
"athol" <me@.privacy.net> wrote in message news:1113708515.863405@.idlweb...
> In aus.cars stewart_connor@.netzero.com wrote:
> [snip quoting of a shite post that never even got to my server]
> If you're going to respond to this shite, snip anything irrelevant
> (ie the whole lot) and then we won't know that you're a fecking
> stupid top-poster.
> --
> Athol
> <http://cust.idl.com.au/athol> Linux Registered User # 254000
> The state of Australia's infrastructure is a national disgrace.
> I'm a Libran Engineer. I don't argue, I discuss.