SQL 2005 + SQL express side by side

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PK - 16 Jul 2008 10:27 GMT

dear all,

we are rolling out a new SQL 2005 server to replace our current 2000 box,

However one application will install SQL express 2005 as its database during
the install process.

Question
Will SQL 2005 and SQL Express 2005 sit side by side on the same server quite
happily..? with no ill effects..

many thanks
Paul

Reply to this Message

Uri Dimant - 16 Jul 2008 10:50 GMT

PK
It depends on many factors such as workload/memory/fast disks. Each instance
consumes memory so make sure that you have enough memory on the server

> dear all,
>
[quoted text clipped - 11 lines]
> many thanks
> Paul

Reply to this Message

Chris Wood - 16 Jul 2008 15:42 GMT

Uri,

In this situation if you have to apply SQL updates, the MS08-040 ones, is
there an order this should be done in? SQL2005 first followed by SQL2005
Express.

Thanks

Chris

> PK
> It depends on many factors such as workload/memory/fast disks. Each
[quoted text clipped - 16 lines]
>> many thanks
>> Paul

Reply to this Message