Path: csiph.com!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Handling New Versions Date: Thu, 10 May 2012 23:50:24 +0200 Organization: Erland Sommarskog Lines: 22 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="27443"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX194N7wOuGoh3AcXicZoR9jp" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:gOIfYP3eHGWwrxyY8d8msOcKZss= Xref: csiph.com comp.databases.ms-sqlserver:1038 Gene Wirchenko (genew@ocis.net) writes: > OK, but considering that you can have multiple instances on one > machine, it strikes me as odd that you can not set it up there EASILY. You can have the test environment on the same box if you want to. In most shops that would not be comme-il-faut though. Overall, I see multiple instances as a developer features. For instance it permits me to have SQL 2005, 2008 and 2012 on my desktop. While it happens that shops runs multiple instance on production servers, I would say that using different virtual machines is a better choice today. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx