Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL 2008 & 2005 (same box)

Author  Topic 

kappa02
Yak Posting Veteran

65 Posts

Posted - 2009-04-28 : 08:57:14
SQL 2008 should be able to run on the same box as MS SQL 2005, correct ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-28 : 09:06:16
Yes.
Please notice that only one instance can be the default instance.
The other instance must be referred to as [machine]\[instance] in your connectionstring.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2009-04-28 : 09:54:19
Also remember that these two instances will be fighting over the same physical memory, CPU, disk controllers, etc. Make sure that the box is sized appropriately for the load you expect, and that the two instances do not try to squeeze each other out at peak times.
Go to Top of Page
   

- Advertisement -