Different MS SQL versions on a server.
in [Server Configuration]
|
From: john doe on 16 Feb 2010 10:00 If there's different MS SQL versions on a server will they conflict with each other? Please advise and thanks.
From: Jay on 16 Feb 2010 10:22 > If there's different MS SQL versions on a server will they conflict with > each other? No. They can be sometimes tricky to setup (sometimes not) and they will compete for the same CPU and memory, but otherwise, they seem to coexist just fine.
From: john doe on 16 Feb 2010 10:31 Thanks for the info. "Jay" <spam(a)nospam.org> wrote in message news:es1BnvxrKHA.4360(a)TK2MSFTNGP05.phx.gbl... >> If there's different MS SQL versions on a server will they conflict with >> each other? > > No. > > They can be sometimes tricky to setup (sometimes not) and they will > compete for the same CPU and memory, but otherwise, they seem to coexist > just fine. > >
From: Erland Sommarskog on 16 Feb 2010 11:53 john doe (johndoe(a)johndoe.com) writes: > If there's different MS SQL versions on a server will they conflict with > each other? With regards to different server instances, there is no problem to have a mix of SQL Server version, as each instance is independent. The tools are a somewhat different story. If you have both SSMS 2005 and SSMS 2008, there are some features (handling of so called solutions) that will only work in one of them. This is rarely any big deal, as once you have SSMS 2008, you can use it both for SSMS 2005 and SSMS 2008. -- Erland Sommarskog, SQL Server MVP, esquel(a)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 SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|
Pages: 1 Prev: How to get a database out of recovery mode Next: Rebuild Index on SQL 2005 |