Hello everybody !

I hope this is the right place for my questions.

I would like to know whether there is a possibility to make available the
same data on two(or more) different instances of the database server, each
instance installed on a different computer.

Thank you very much !
Ernest

There is no native SQL Server multi-host, single-data-set scale out
technology.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"ernest" <ernest (AT) gesora (DOT) com> wrote

There is a technology available in SQL Server 2005 called Scalable Shared
Databases. However, I have not heard of anyone implementing this technology
yet and it is read-only. Basically, you copy your data to a SAN volume,
mark that volume as read-only, and attach it to multiple servers. Check out
this article for more info. http://support.microsoft.com/kb/910378

Other than that, if you have more control over your application and
database, Peer-to-Peer Replication is about as close as you are going to
get. This is not an "Add-on" technology though and the application
architecture must support it.

Hope this helps!

Rick Heiges
SQL Server MVP

"ernest" <ernest (AT) gesora (DOT) com> wrote