> Justin wrote: > > > > > > aravind chandu wrote: > > Hi, > > >> My question is > > >> Microsoft sql server 2005 cannot be shared on multiple systems > > i,e in a network environment when it is installed in one system it > > cannot be accessed one other systems. > > > > > > This don't make any sense. Are your taking about sharing the actual > > mdb files or access the service itself??? This question is just > > confusing. > > > > > > Your Questions are confusing can you clarify > > I'm guessing at what you mean??? > He's talking about having the raw database files on a file server (eg > SMB share). DB's like firebird and sqlite can handle this way of > accessing the data using the embedded engines. Active-active, multiple server databases are either a shared nothing or a shared disk system. Oracle, for instance is a shared disk system where multiple database instances can connect to the same underlying disk. Greenplum, Teradata, and Netezza are examples of shared nothing systems. http://en.wikipedia.org/wiki/Shared_nothing_architecture http://en.wikipedia.org/wiki/Shared_disk_file_system PostgreSQL does not have either a shared disk or shared nothing architecture. It is similar to SQL Server where replication and/or failover is how you can get high availability. http://www.postgresql.org/docs/8.3/interactive/high-availability.html Greenplum and EnterpriseDB are both based on PostgreSQL and use a shared nothing architecture to achieve and active-active system. Jon
